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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.