11.7 The Common SQL interface

The Common SQL interface requires ODBC or one of the supported database types listed in section "Supported databases" of the LispWorks User Guide and Reference Manual .

11.7.1 Loading the Common SQL interface

To load the Common SQL interface to use ODBC enter:


(require "odbc")

and at runtime call:


(sql:initialize-database-type :database-type :odbc)

and then you can connect to any installed ODBC datasource.

To load the Common SQL interface to use MySQL, enter:


(require "mysql")

and at runtime call:


(sql:initialize-database-type :database-type :mysql)

See the LispWorks User Guide and Reference Manual for further information.