How To Fix Visual Basic Runtime Error 40002 Tutorial


Home > Runtime Error > Visual Basic Runtime Error 40002

Visual Basic Runtime Error 40002

Contents

I am on NT > 4.0 SP6 using MS SQL Server 7.0 SP 3. > > This very same code used to run in NT 4.0 SP6 using MS SQL Server Reply With Quote Nov 6th, 2007,12:01 PM #2 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif. Before test, I import all related tables from prodction server to test server. Run an install, and see if that helps. http://nbxcorp.com/runtime-error/visual-basic-runtime-error-53-dll.html

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. Get 1:1 Help Now Advertise Here Enjoyed your answer? I am on NT 4.0 SP6 using MS SQL Server 7.0 SP 3. My users are using another server. http://forums.codeguru.com/showthread.php?502041-VB-6-0-Run-time-error-40002-37000-the-cursor-was-not-declared

Runtime Error 40002 Odbc

I once encounterd similar problem, but was rectified after i ran the service pack. Originally Posted by RobDog888 Debug your sql statement by placing a breakpoint on the .Execute line. Join the community of 500,000 technology professionals and ask your questions. Sat, 21 Nov 1998 03:00:00 GMT Kevin Alti#2 / 3 rdo what is the error runtime 40002 ?

Originally Posted by RobDog888 If one of the cbos is empty then the .Text property for it will be a nullstring which may give you the wrong returns. Having these kinds of errors does not always mean that you have to replace your computer, sometimes it just needs some troubleshooting effort from you. The date part when tried on the access database fails when reverted to my original bit of code for date the select statement works fine on access but not the SQL Just try the new installation package and see if that makes a difference.

Raiders #1 AKA:Gangsta Yoda™ Posts 60,221 Re: error 40002 01000:Statement has been termineted. Runtime Error 40002 Sql Server And it is also not the problem of permission to access certain table, because such problem would not cause run time error. Share a link to this question via email, Google+, Twitter, or Facebook. website here Originally Posted by RobDog888 It could be that you are trying to insert a record without providing all the required fields as one may not be allowing null values.

To start viewing messages, select the forum that you want to visit from the selection below. Greetings and Best Regards, Stefaan Lesage E-mail : [email protected] 0 Message Author Comment by:chuatj1999-03-07 Thanks very much. 0 Featured Post How to run any project with ease Promoted by Quip, Originally Posted by RobDog888 But what I mean is the other way around. You need to identify what the difference is between your system and theirs.

Runtime Error 40002 Sql Server

Please post a thread in the appropriate forum. http://p2p.wrox.com/archives/beginning_vb/2001-12/40.php MS SQL Server SQL - Selecting Rows and Columns Video by: Zia Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various Runtime Error 40002 Odbc Visit our Linux sister site. Runtime Error 40002 Vb6 Privacy Policy Site Map Support Terms of Use Need to download code?

Reply With Quote 05-28-2003,10:24 AM #2 skhanal View Profile View Forum Posts Experts Join Date Nov 2002 Location New Jersey, USA Posts 3,896 Your join statement needs to be changed, try his comment is here Browse other questions tagged sql-server vb6 rdo or ask your own question. Join our community for more solutions or to ask questions. 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

Results 1 to 4 of 4 Thread: VB 6.0 Run time error 40002 - 37000 the cursor was not declared Tweet Thread Tools Show Printable Version Email this Page… Subscribe to Please post a thread in the appropriate forum section. Connection Strings Reply With Quote Nov 6th, 2007,12:07 PM #4 lucia View Profile View Forum Posts Thread Starter Hyperactive Member Join Date Nov 2001 Posts 313 Re: error 40002 01000:Statement has http://nbxcorp.com/runtime-error/visual-basic-runtime-error-53.html Join them; it only takes a minute: Sign up Query Insert failed through VB 6 application up vote 0 down vote favorite I am working on a VB application which will

Are you using ODBC to make a connection? Thank you for your guidance. 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

I think it should be installed fine since it is not a new app.

Message #2 by "Tom Carr" on Thu, 20 Dec 2001 21:33:12 I don't know if the following would be any help: PRB: Jet ODBC Driver Error 40002: Operation Invalid at I would check for no selection before they click the query button. I checked support.microsoft.com and they have an article Q280134 that discusses something similar, however, in my code I *am* using the rdExecDirect as the option on the .Execute method of the Reply With Quote Nov 6th, 2007,12:22 PM #6 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif.

Visit our Linux sister site. Extract picture from database without using hard drive . Try to reinstall the client files on that PC, and also make sure you applied the same Service Pack on all client machines as the one you applied to the SQL navigate here Is it a shared database or do you have your own copy on your system?

First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone.