This library provides ODBC access procedures.
ODBC is a common database access interface so that it doesn't depend on specific APIs. This library is for implementing ODBC DBD for DBI, using this library directly is not recommended.
NOTE: the library is supported only your platform is supporting ODBC.
Creates and returns ODBC environment object.
Returns #t if the given obj is ODBC environment object.
Releases given ODBC resource.
odbc-env must be an ODBC environment object created by
create-odbc-env.
server must be a string indicating ODBC database name.
username and password must be string.
Connects to server with authentication of username and password and returns ODBC database connection object. If optional argument auto-commit is #f then the connection won't commit transaction automatically.
Returns #t if the given obj is ODBC connection object.
Disconnect from the database.
Returns #t if the given ODBC connection is available, otherwise #f.
Creates and returns a ODBC statement object.
Returns #t if the given obj is ODBC statement object.
Returns #t if the given ODBC statement is available, otherwise #f.
Returns number of parameters in an SQL statement.
Binds the given value at position index.
Execute given ODBC statement.
Forwarding current cursor to next and returns #t if there is data otherwise #f.
Retrieve data from statement at position index.
Returns the number of rows affected by UPDATE, INSERT or DELETE statement.
Returns the number of columns in a result statement.
Returns the column names in a result statement.
Commits/rollbacks given ODBC context.
This library provides database driver (DBD) for ODBC .
Importing this library is done by DBI automatically so users should not use this directly.
The DSN should specify the connecting database name with server keyword.
Following DSN is connecting foo database configured in ODBC.
"dbi:odbc:server=_foo_"The dbi-connect supports :username, :password and
:auto-commit keyword arguments. The detail about DBI see
(dbi) - Database independent access layer.