ODBC Error 3146

[CInman]

I understand that this is a "generic", high-level ODBC error that is sometimes returned by my VB app. using ODBC to access SQL Server 7. My problem is that I did not write the VB app, and do not have access to source, so is there a way to decode the cause of the ODBC 3146 erorr? In other words, find out what the problem is?
Any help or suggestions even would be really appreciated as I've now been stuck for ages on this one.

 

[Spellman]

My suggestion would be to check the Microsoft Knowledge base for that error number and see what it comes up with. I checked it out and heres what it came up with. Hope it helps.

Early versions of the ODBC Driver Manager (1.x) were placed in the Windows directory on 16-bit Windows platforms, while subsequent versions of the ODBC Driver Manager (2.x and above) were placed in the Windows\System directory. The best way to determine if you are encountering the problem is to search the computer for the Odbc.dll file, and verify the version in File Manager. You can do this by clicking on the file and then clicking Properties on the File menu. If the first possible Odbc.dll file in the path is the ODBC 1.x Driver Manager, you are most likely encountering the problem.



WORKAROUND
To work around this problem, remove the ODBC 1.x Driver Manager (Odbc.dll) from the path and/or place the ODBC 2.x Driver Manager (Odbc.dll) in the path first.

 

[CInman]

Thanks Spellman, that makes sense and I'll see what I can find. Much appreciated.