This is quite a strange error that occurred after applying SP2 to SQL2005. This code has worked for 10 years prior to this using VB6, including running against SQL2005 SP1. The error occurs on the last line of the code excerpt (in bold). How should this error be handled? Thanks.
Err.Number = -2147467259
Err.Description = Data provider or other service returned an E_FAIL status.