Database Search

match allmatch any Look in all areasLook in current areas Check all datesPrevious dayPrevious 3 daysPrevious weekPrevious fortnightPrevious monthPrevious 2 monthsPrevious 3 monthsPrevious half-yearPrevious year

TechHome

	ADSI LDAP CDO
	Samples from Users

• !!! Simple ADO Example !!!
• !ADO Object Model
• 1255 OLE Member Not Found
• ADO - ADOX requirements
• ADO - DAO Constants
• ADO AD Sort Problem
• ADO and GetObject
• ADO and Large Numbers
• ADO Convert Access data to Tab Delimited Text File
• ADO CreateParameter
• ADO Data Control Constants
• ADO Data Shaping
• ADO Error Issue
• ADO Error Object
• ADO Find vs DAO Seek Access Example
• ADO Jet Order By Clause
• ADO links
• ADO Sample for Stored Procedure
• ADO SaveAs and Excel or Convert Before Closing
• ADO Schemas
• ADO softseek
• ADO SQLOLEDB Example
• ADO Stream Binary File Download
• ADO Stream to Binary Buffer
• ADO with mySQL
• ADOX Append Table Columns
• ADOX Grant Permissions
• ado_seek
• Auto Form For ADO Database Tables
• Auto Generate GUIDs
• Basic Database Dialog Sample
• Beginner ADO Question
• Check Who is Using an MDB
• Close an Active Connection
• Connect to SQL Server 2000 MSDE
• Converting Text String to 4-char Soundex String
• Create Address Book XML File
• Create ADO Get and Put UDFs for Selected Database Table
• Create an AutoIncrement Column in Access
• csv2acc - ADO - CSV-delimited to MDB conversion
• csv2acc2 - ADO - CSV-delimited to MDB conversion2
• DAO CreateTableDef
• Delete All Records from Access Table
• Error 1261 using SetInfo Method
• Extract Column Data Using ADO
• Generic Recordset to Text file UDF
• Get Create_date From SQL Server Table Properties
• Get Extended ADO Connection-Version Info
• Get Result Data of Select Statement
• Get Users Email Address in Active Directory
• GetRows Array Results Explained
• How to Filter Records
• Import Data into My SQL
• Insert Rows From One Database to Another
• Inserting Rows that Contain Apostrophe
• Large Database Query Example
• Learning ADO Conversion to Winbatch
• Lock Database in ADO
• Long Discussion on ADO and Creating a Table
• Microsoft Access Database Engine 2010 Redistributable
• MySQL UDFs
• OLE and DAO Example
• OLE DB Data Link Properties Dialog
• Ole Exception ADODB Recordset
• OLE Exception Connecting to Oracle ODBC Driver
• Ole Exception ParentCatalog ADOX
• Parent-Child Fabricated Recordsets
• Playing around with ADO Schemas
• Problem Getting Record Count via ADO
• Retrieve all user objects in a domain via ADO
• Return a Value from an ADO array
• Samples for creating ADO connections
• Simulate Alter Structure for Persisted XML Recordset
• SQL Server 2005 XML with Winbatch
• SQL Server Blank Password
• SQL Server Update Using ADO
• SQLOLEDB Provider Error
• Stored Procedure with Return Value
• Streaming Recordset To Browser
• Tip - Avoid Duplicate Errors in Bulk INSERTS
• Use ADO to Insert Data From CSV Into Excel
• Use the Datalinks Dialog to insert ADO Connection info into a script
• Very Basic Database - Dialog ADO Sample
• Visual ADO Connection
• Wildcard for SQL LIKE Using ADO
• Write BLOB to MySQL

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

ADO Error Object

 Keywords: ADO Error Errors ADODB Connection errorhandling

---

ADO errors are reported to your script as run-time errors. You can use errorhandling to trap and handle them. (ErrorMode or IntControl 73)

You can access error information from the error object.

For Example:

#DefineFunction udfErrorHandler(wberrorarray)
   lasterr = wberrorarray[0]
   handlerline = wberrorarray[1]
   textstring = wberrorarray[5]
   linenumber = wberrorarray[8]
   errstr = StrCat("Number: ",lasterr,@LF,"String: ",textstring,@LF,"Line (",linenumber,"): '",handlerline,"'")
   Message("WIL Error Information",errstr)
   Return 1 ;Re-arm error handler
#EndFunction

IntControl(73,3,1,'udfErrorHandler',0); Defines and sets the error handler UDF.

objConn = CreateObject("ADODB.Connection")
objError = objConn.Errors
ret = objConn.Open("nothing")  ; !!! Intentionally trigger an error. !!!

If objError.Count > 0
 ;list Errors collection and display properties of each Error object.
 ForEach errLoop In objConn.Errors
      strError = "Error #" : errLoop.Number : @CRLF :"   " : errLoop.Description : @CRLF :"   (Source: " : errLoop.Source : ")" : @CRLF :"   (SQL State: " : errLoop.SQLState : ")" : @CRLF :"   (NativeError: " : errLoop.NativeError : ")" : @CRLF
      If errLoop.HelpFile == ""
         strError = strError :"   No Help file available"
      Else
         strError = strError :"   (HelpFile: " : errLoop.HelpFile : ")" : @CRLF :"   (HelpContext: " : errLoop.HelpContext : ")"
      EndIf
      Pause('ADODB error', strError)
  Next
EndIf
Exit

---

objConn = CreateObject("ADODB.Connection")
ErrorMode(@OFF)
objConn.Open("nothing")  ; !!! Intentionally trigger an error. !!!
ErrorMode(@CANCEL)
If objConn.Errors.Count > 0
 ;list Errors collection and display properties of each Error object.
 ForEach errLoop In objConn.Errors
      strError = "Error #" : errLoop.Number : @CRLF :"   " : errLoop.Description : @CRLF :"   (Source: " : errLoop.Source : ")" : @CRLF :"   (SQL State: " : errLoop.SQLState : ")" : @CRLF :"   (NativeError: " : errLoop.NativeError : ")" : @CRLF
      If errLoop.HelpFile == ""
         strError = strError :"   No Help file available"
      Else
         strError = strError :"   (HelpFile: " : errLoop.HelpFile : ")" : @CRLF :"   (HelpContext: " : errLoop.HelpContext : ")"
      EndIf
      Pause('error', strError)
  Next
EndIf

---

Article ID:   W18032

Filename:   ADO Error Object.txt

File Created: 2009:07:23:08:57:58

Last Updated: 2009:07:23:08:57:58