Chuatj, I'm almost sure the problem lies with one of the client DLL's. Generate antsy permutations email etiquette adding people to the thread vs reaching out directly How common is it to use the word 'bitch' for a female dog? Advanced Search Forum Miscellaneous Ask an Expert No cursor was declared If this is your first visit, be sure to check out the FAQ by clicking the link above. Please post a thread in the appropriate forum. Source
is there any instuction I can read? Is there a code work around? How to comment blocks of code in VB5 and VB6 . We have tried that and it seems that it is the DBNMPNTW.DLL file problem. official site
I let use select what they want and to run a report. Thanks. Please post a thread in the appropriate forum section. MS SQL Server Advertise Here 767 members asked questions and received personalized solutions in the past 7 days.
Originally Posted by Hack Create an installation and setup package with your new Exe in it. Reply With Quote Nov 6th, 2007,01:40 PM #17 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif. The second would be to check permissions on the database table you are trying to access. When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
And why odbc at all? Suggested Solutions Title # Comments Views Activity VB.net list SQL views in the order they were created 4 22 14d SQL syntax, SEL FROM sys.messages WHERE sys.messages.text LIKE ' %NULL%' 4 I am on NT 4.0 SP6 using MS SQL Server 7.0 SP 3. http://www.dreamincode.net/forums/topic/289070-run-time-error40002/ VB/Office Guru™ (AKA: Gangsta Yoda™ ®) I dont answer coding questions via PM.
Last edited by lucia; Nov 6th, 2007 at 12:15 PM. Your version of ODBC may not support ANSI join syntax, try this one if you have to use ODBC SELECT ST.STUD_Student_ID , ST.STUD_Surname_S02 , ST.STUD_Forname_1_S03, se.STEN_Student_ID, se.STEN_Prog_code FROM STUDstudent AS ST, Run an install, and see if that helps. Please post a thread in the appropriate forum section.
I have a form with 4 combo boxes. http://p2p.wrox.com/archives/beginning_vb/2001-12/40.php Maybe it's the same for Oracle? Runtime Error 40002 Odbc My users are using another server. Runtime Error 40002 Vb6 Please post a thread in the appropriate forum.
Having said that, installing of these things might cause an error that causes a flash of blue screen each time you boot up your computer. http://techkumar.com/runtime-error/runtime-error-5-vba.html How do XMP files encode aperture? Before test, I import all related tables from prodction server to test server. This may also occur when your application is taking or leaking out a lot of memory.
Just that the DLL which is causing the problem is the Net Library for communication through Named Pipes. Did you configure odbc on your client's workstation? Advanced Search Forum Visual Basic Programming Visual Basic 6.0 Programming VB 6.0 Run time error 40002 - 37000 the cursor was not declared If this is your first visit, be sure http://techkumar.com/runtime-error/how-to-fix-runtime-error-339.html VB4/SQL Workaround for RollBackTrans & Error 40002 Powered by phpBB Forum Software Fixit Search Primary Menu Skip to content Search for: Run Time Error ‘40002' In Visual Basic June
Microsoft MVP 2006-2011 Office Development FAQ (C#, VB.NET, VB 6, VBA) Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET If a post has helped you then Please Rate Board index » Visual Basic All times are UTC rdo what is the error runtime 40002 ? Blue Screen of Death To make your computer more up-to-date, you should keep on updating its system, because of this, we keep on installing new hardware and softwares.
Please use [Code]your code goes in here[/Code] tags when posting code. When you have received an answer to your question, please mark it as resolved using the Thread Tools menu. Error : 40002 - 01S03: [Microsoft][ODBC SQL Server Driver]No rows updated or deleted 12. http://support.microsoft.com/kb/186196 Reply With Quote September 1st, 2010,01:46 AM #3 msmnithya View Profile View Forum Posts Junior Member Join Date Oct 2007 Posts 9 Re: VB 6.0 Run time error 40002 -
It does not matter if you have the newest operating-system because no matter what kind of OS you're using, you are still prone to this error. Please use [Code]your code goes in here[/Code] tags when posting code. But what I mean is the other way around. Check This Out This stored procedure is accessible in the database and I can run it from the command line in SQL Server 'StartImport'.
Trouble shooting Run Time Error ‘40002' In Visual Basic requires the same method. Regards, Tay Jin 0 LVL 3 Overall: Level 3 MS SQL Server 1 Message Expert Comment by:Stefaan1999-02-24 Hi, Well actually I thought it would be something like I said. If this is your first visit, be sure to check out the FAQ by clicking the link above. VB/Office Guru™ (AKA: Gangsta Yoda™ ®) I dont answer coding questions via PM.
All you should do is open the control panel and proceed to system and security, it will then take you to the advanced system settings and begin changing it.