ADO Error Issue
Question:
For some reason I am now getting the following type of response for my ADO SQL Errors. It tells me that "ODBC driver
does not support the requested properties." Is there a way to get a more useful response? I am sure there used to be
a useful response in the very recent past but I'm not sure what changed. I get this type of error any time my SQL
script is wrong in some fashion. Example: Rather than telling me that the "mytable" table doesn't exist it gives me
the above-mentioned response. Any ideas. I'm sure I'm overlooking something simple but I'm not sure what.
Answer:
I assume you checked into the ADO Error Object (derived from the Connection).
User Reply:
I've added this but it generates the exact same message.
If myConn.State > 0 Then
cnt = myConn.Errors.Count
message(cnt,myConn.Errors(0).Description)
EndIf
Answer:
So you seem to be saying that the ADO errorhandler and wb additionalinfo appear equivalent
and neither makes any sense... sounds like the old Microsoft "Multi-step operation generated errors"
catch all. Perhaps another ADOerror property like the SQLState gives a better clue.
User Reply:
I tried SQLState. It comes back as a zero every time.
Resolution:
Just to complete this thread in case anyone else encounters the same problem. Setting the CursorLocation to 3 fixed the problem.
Article ID: W17103
File Created: 2007:07:03:14:28:20
Last Updated: 2007:07:03:14:28:20