ADOConnection

Available since framework version 1.0.

Defined in : DataBases.con
(this file must be included in your application in order to have access)

Require : standard.db.sql,standard.lib.str

Description:

This is a class for connecting to a database server. It uses the ODBC standard and on linux requires the iODBC or unixODBC libraries. Using this, you can connect to any data base server that provides an odbc interface. This control was successfully tested with: MS SQL, MySQL, Access and more.

Properties

Connection
The connection handle as returned by the odbc library
EndTransaction
Ends the current transaction
LastError
The last error(s) encountered by the connection related processed, as a string

Methods

ADOConnection
This is the standard contructor for this class and should not be used directly
Close
Closes the current connection
ListColumns
List columns in a table
ListDSN
TODO: Document this
ListTables
List the tables in a database
Open
This function tries to connect to a odbc driver specified by the connection string
OpenDSN
This function tries to connect to system or user DSN
StartTransaction
Switch to user controlled transaction