ODBC

Libraries

The ODBC back-end requires access to an ODBC driver manager as well as ODBC drivers for the underlying database server. CLSQL has been tested with unixODBC ODBC Driver Manager as well as Microsoft's ODBC manager. These driver managers have been tested with the psqlODBC driver for PostgreSQL and the MyODBC driver for MySQL.

Initialization

Use

(asdf:operate 'asdf:load-op 'clsql-odbc)
	  

to load the ODBC back-end. The database type for the ODBC back-end is :odbc.

Connection Specification

Syntax of connection-spec

(dsn user password)

Description of connection-spec

dsn

String representing the ODBC data source name.

user

String representing the user name to use for authentication.

password

String representing the unencrypted password to use for authentication.

Notes

FDDL

  • The :owner keyword argument to the FDDL functions for listing and testing for database objects is ignored.