I'm working with a SQL Server Database, this way: I create in my VB5 App a local Jet DB, and link these tables to the SQL Server remote tables through ODBC.
My problem is error handling from VB: When an error occurs I always get same error: '3146: ODBC call failed.'
Before that I used to link my local tables to a remote Jet DB (Access), and when an error occurred it tells me what kind of error, like a duplicated index, or Field needed, or Can't delete because there is a related record in another table ... and so.
But now I don't know how to get more information about what kind of error it happened. Can you help me?
Thanks in advance.