Complete ODBC error Message which we get when we run the SQL query

[Riya07]

Hi,

Would need your help in displaying the complete error Message which i get if data is not found

In my code, my errorMode is set to 0

and then ScriptError just gives the generic error like File Has Wrong Format. i have ScriptErrorDetails and ScriptErrorList also specified in my code to capture the complete database error but they are returned as null

Is there a way, we can get the complete error message from DB.

[mpc]

Hi, 

Since setErrorMode = 0, you'll note have this info. without scripting. 
Maybe you can try something like this:

if ScriptError=3 then

setErrorMode = 0;

//Retry your SQL Query

end if

It should display the full ODBC error

Regards