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.
Printable View
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?
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?
No sp's applied, compatibility level is 80
Apply sp4 if possible.
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.