Description:
ODBC library for database control. This is a low level library. Instead of this, is recommended that you use the
ADOConnection,
ADODataSet and
ADODataRecord objects.
The ODBC (Open DataBase Connectivity ) is a standard for handling various types of database engine (including MS SQL and MySQL via MyODBC on both windows and penguins).
On linux or BSD systems (penguins) you should install the unixODBC or iODBC library before you compile this library. Concept doesn't provide data base specific libraries (like MySQLConnect or MSSQLConnect). Instead, you have this ODBC library that should provide access to most common used database engines.
Methods
Add a parameter to a statement handle (same as result set)
Changes the default commit mode
Clear the parameters added to a previously created statement with
ODBCStatement
Get the data on the given column index on the current record
Connect to a database using a DSN(Data Source Name)
Get the number of columns in the current result set
Get the number of rows in the current result set
Describe a column in a result set
Disconnects a previously connected driver
Get the name of the driver used for the given connection
Connects to a database using a connection string
Get the last encountered errors, as reported by the ODBC driver
Create and executes a statement
Position the current record on the given row (by its index) in the given data set
Position the current record on the first row in the given data set
This function should be used only when working with MySQL and tables that contain big text fields
Position the current record on the last record in the given data set
Position the current record on the next row in the given data set
Position the current record on the previous row in the given data set
Get the name of the first system DSN(or user DSN, depending on the rights the application is using)
Get the list of column names in specified tables
Get the list of table, catalog, or schema names, and table types, stored in a specific data source
Get information about data types supported by the data source
Lock the access to a record
Get the name of the next system DSN(or user DSN, depending on the rights the application is using)
Get the absolute position of the current row
Jump over a given number of rows
Create an empty result set
Unlock the access to a previously locked record
Get the last encountered warnings, as reported by the ODBC driver