I'm still on the VB6 platform with this project. Do you know if there is an equivalent for the sqlexception object in VB6? I checked the ADODB.Error object but it...

Adding an extra output parameter to all stored procedures would have an important impact on all stored procedures and vb code.  And it would only work when the stored procedure...

I was looking for a solution where the OLE DB driver automatically translates UTC datetime fields according the clients timezone. Much like the setSessionTimeZone of Orcale.

Ok. Great suggestion.

Can I conclude form this solution that there is no application quit event that can be captured. Obvious this would result is more straight forward coding.