19.1.2 Supported databases
Common SQL supports connections to various databases on the platforms indicated below in Supported databases. Common SQL may work with other platform/ODBC driver combinations and we would be pleased to hear of your experience with these. The keyword shown in the last column is the corresponding value of the
database-type
argument to connect:
Supported databases
|
Platform
|
Database
|
Driver/Client library
|
database-type
|
|
Windows
|
ODBC
|
Microsoft SQL Server
|
:odbc
|
|
Windows
|
ODBC
|
Oracle
|
:odbc
|
|
Windows
|
ODBC
|
Postgres
|
:odbc
|
|
Linux
|
ODBC
|
MySQL
|
:odbc
|
|
Linux
|
ODBC
|
Postgres
|
:odbc
|
|
Mac OS X
|
ODBC
|
MySQL
|
:odbc
|
|
Mac OS X
|
ODBC
|
Postgres
|
:odbc
|
|
Linux
|
Oracle
|
Oracle 9i (r2) or 10g
|
:oracle
|
|
Mac OS X/Intel/32-bit
|
Oracle
|
Oracle 10g
|
:oracle
|
|
Mac OS X/Intel/64-bit
|
Oracle
|
Oracle 10g
|
:oracle
|
|
Mac OS X/PPC/32-bit
|
Oracle
|
Oracle 10g
|
:oracle
|
|
Windows
|
Oracle
|
Oracle 9i (r2) or 10g
|
:oracle
|
|
Solaris/Intel
|
Oracle
|
Oracle 10g
|
:oracle
|
|
Solaris/SPARC
|
Oracle
|
Oracle 9i (r2) or 10g
|
:oracle
|
|
HP-UX
|
Oracle
|
Oracle 9i (r2) or 10g
|
:oracle
|
|
Linux
|
Oracle
|
Oracle
|
:oracle8
|
|
Solaris/SPARC
|
Oracle
|
Oracle
|
:oracle8
|
|
HP-UX
|
Oracle
|
Oracle
|
:oracle8
|
|
Linux
|
PostgreSQL
|
Postgres
|
:postgresql
|
|
FreeBSD
|
PostgreSQL
|
Postgres
|
:postgresql
|
|
Mac OS X
|
PostgreSQL
|
Postgres
|
:postgresql
|
|
Windows
|
PostgreSQL
|
Postgres
|
:postgresql
|
|
Solaris/Intel
|
PostgreSQL
|
Postgres 8.2
|
:postgresql
|
|
Linux
|
MySQL
|
MySQL
|
:mysql
|
|
FreeBSD
|
MySQL
|
MySQL
|
:mysql
|
|
Mac OS X
|
MySQL
|
MySQL
|
:mysql
|
|
Windows
|
MySQL
|
MySQL
|
:mysql
|
|
Solaris/Intel
|
MySQL
|
MySQL
|
:mysql
|
|
Solaris/SPARC
|
MySQL
|
MySQL
|
:mysql
|
Note: MySQL versions prior to 4.1.1 should be run in ANSI mode to work with Common SQL. That is,
mysqld
must be started with
--ansi
or the
ansi
option must appear in the
[mysqld]
section of its configuration file.
Note: To use PostgreSQL on any non-Microsoft Windows platform, LispWorks/Common SQL requires PostgreSQL version >= 8.x built with
--enable-thread-safety
.
LispWorks User Guide and Reference Manual - 22 Dec 2009
