-
SQL Error 40002
When saving to db sql chucks out error 40002 and kills application. Application was written in VB5 with data recently migrated from sql7 to sql2000.
-
What's the full error message.
-
Maybe mdac version mismatch, try upgrade mdac on app server.
-
Updated MDAC still getting same error. SQL2000 running on server 2003 with xp on clients. Error only occurs when saving data, application will open and read data.
Thanks in advance
-
Do you have complete error message?
-
Full error message reads.
Runtime error 40002
01000: [Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER] this statement has been terminated.
Again thanks in advance
-
Do you have same version of mdac on both server and client machine?
-
Mdac
Indeed I do have the same version of mdac running on both app server and clients...
-
Did you apply any sql2k service pack? Is the db in compatibility level 80?
-
Compatibility
No sp's applied, compatibility level is 80
Last edited by davidb; 01-17-2007 at 04:38 AM.
Reason: forgot to add in additional text
-
-
sp4 applied still same as any ideas?
-
product version: 8.00.2039
product level: sp4
edition: enterprise edition
-
are u using ADO in the VB app (i hope)?
try using oledb rather then odbc driver.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|