ADO SQLState Property

Complete Error Object Reference

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("<p>")
  response.write("Description: ")
  response.write(objErr.Description & "<br />")
  response.write("Help context: ")
  response.write(objErr.HelpContext & "<br />")
  response.write("Help file: ")
  response.write(objErr.HelpFile & "<br />")
  response.write("Native error: ")
  response.write(objErr.NativeError & "<br />")
  response.write("Error number: ")
  response.write(objErr.Number & "<br />")
  response.write("Error source: ")
  response.write(objErr.Source & "<br />")
  response.write("SQL state: ")
  response.write(objErr.SQLState & "<br />")
  response.write("</p>")
next
%>

Complete Error Object Reference

Altova® XMLSpy® - The world's best-selling XML editor!

Whether you're new to XML or already an advanced user, the user-friendly views and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to meet your XML and Web services development needs from start to finish.

• XML editor
• Graphical XML Schema / DTD editors
• XSLT 1.0/2.0 editor, debugger, profiler
• XQuery editor, debugger, profiler
• Support for Office Open XML (OOXML)
• Graphical WSDL editor & SOAP debugger
• Java, C#, C++ code generation
• And much more!

Download a free 30-day trial today!

Jump to: Top of Page or HOME or Printer friendly page

W3Schools provides material for training only. We do not warrant the correctness of its contents. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2008 by Refsnes Data. All Rights Reserved.

W3Schools was converted to XHTML in December 1999