19.12.2 Loading unixODBC

At load time do:

At runtime, Common SQL automatically loads the unixODBC module from the location in the variable sql::*odbc-foreign-modules* . In LispWorks for Linux this variable initially has the value ("/usr/lib/libodbc.so") . Therefore if, for example, the runtime machine unixODBC installed in
/usr/local/ , at runtime do:

(setq sql::*odbc-foreign-modules* '("/usr/local/lib/libodbc.so"))

(sql:connect "mydatabase" :database-type :odbc)

LispWorks User Guide and Reference Manual - 21 Dec 2011