10.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.

10.7.1 Loading the Common SQL interface

To load the Common SQL interface to use ODBC enter:

(require "odbc")

and at run time 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 run time call:

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

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