I'm having problems with handling errors returned from a Sybase database. We use an ODBC driver with ADO as an access interface between my VB 6.0 front end. The problem is when the database returns an error for some reason, the connection object supplies no numbers associated with the errors. It recognises that an error has occured but supplies no error number.
So for example, whereas
ADODB.Connection.Errors.Count will contain a value,
contain the value '0' regardless of the nature of the error, As you can imagine, this makes distiguishing between the various errors rather difficult . .
Is anyone aware of any incompatibility between any versions of Sybase and ODBC? Or problems using ADO with ODBC?