Interface to ODBC connections.
Class ODBC( connect, [options] )
| connect | String containing connection parameters. |
| options | Connection and query default options. |
The ODBC drivers have a limited ability to determine the underlying database types; for this reason, it's advisable to limit the usage of prepared statements, and rely on query, which performs safer verbatim parameter expansion.
The connect string is directly passed to the ODBC driver for connection, so it must respect ODBC standards and specific extensions of the target database.
Other than the base DBI class options, this class supports the following options:
- bigint (on/off): By default, the ODBC drivers can't deal with int64 (64 bit integers) data. Setting this on, it is possible to send int64 data through prepared statements.