Post reply

Returning SQL Error details to VB?

  • November 26, 2003 at 2:44 am

    #82867

    Is it possible to return a SQL error to VB?

    I'm using ADO and the text comes through fine, but there is always a generic error number that translates as "an error has occurred".

    He was not wholly unware of the potential lack of insignificance.

    LinkedIn Profile

  • November 26, 2003 at 5:20 am

    #483694

    In ADO you've got the Number, SQLState, and NativeError properties of each error object. I typically use the SQLState when testing expected conditions in an error handling routine, as it's more generic, but I think you want the NativeError property (which I also display and log, along with Source and Description, for unexpected errors).

    --Jonathan



    --Jonathan

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply