ADO SQLState Property

The SQLState property returns a string that contains a 5-character SQL error code returned by the provider.

Syntax

strErrorSQL=objErr.SQLState

Example

<%
for each objErr in objConn.Errors
 response.write("")
 response.write("Description: ")
 response.write(objErr.Description & " ")
 response.write("Help context: ")
 response.write(objErr.HelpContext & " ")
 response.write("Help file: ")
 response.write(objErr.HelpFile & " ")
 response.write("Native error: ")
 response.write(objErr.NativeError & " ")
 response.write("Error number: ")
 response.write(objErr.Number & " ")
 response.write("Error source: ")
 response.write(objErr.Source & " ")
 response.write("SQL state: ")
 response.write(objErr.SQLState & " ")
 response.write("")
next
%>

❮ Complete Error Object Reference