In classic ADO / SQLOLEDB provider, can a successful update return a non-zero error number?
Posted on 2014-11-04
When our legacy application executes an UPDATE statement, our code behaves as if an exception has been raised (and assumes the update has not worked), yet the effects of the update have been found later to be committed to the database.
Due to the infrequency of the issue, we are unable to obtain any exact error numbers or descriptions - we only know the issue is occurring due to the resultant effects on the database tables.
Is it even possible to get non-zero errors from ADO / SQL OLEDB provider when the UPDATE actually succeeds??
Please Note: This is a legacy VB6 app, Classic ADO with SQL OLEDB provider - nothing to do with dot NET.