Scripting an Application Using ADO

Previous Next

To script an application using ADO to connect to a USoft Remote Rules Service API data source:

· Use an ADODB.Connection object to establish a connection to a pre-configured data source based on the "USoft Remote Rules Services 8.0" driver. Refer to the required data source name as a parameter of the ADO method Connection.Open().


· Use ADODB.Command objects to create and execute SQL statements. The SQL must be formulated in ODBC syntax, i.e., with the use of question marks '?' for input parameters and the use of escape characters '{' and '}' around scalar functions.


· Use ADODB.RecordSet object to fetch data.


· Use ADODB.Errors object to retrieve any rules engine violation messages or error messages.