Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Bermuda
    Posts
    40

    Unanswered: ODBC/OLE DB Error Code 0

    Hey All:

    Getting Code 0 errors in ActiveX scripts within DTS & can't trap the decription(s).
    I remember seeing an OLD Thread on expanding the Code 0 errors but can't find it.

    RobbieD
    Sunny Times...

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    copy the contents of your dts into a notepad, save it as vbs file, after putting msgbox in places where you know or think errors occur, and go get them, tiger! happy debugging

  3. #3
    Join Date
    Jan 2004
    Location
    Bermuda
    Posts
    40

    Red face Thanks ms_sql_dba:

    I did something similar. Copied the code into InterDev & got what I was looking for.

    Also, realized that the procedure was flawed (BAD Code, BAD!) in that I was attempting to capture the error from one ActiveX module in a SECOND on Failure. Obviously, the err.Description would no longer exist!!!
    Sunny Times...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •