NextPrevUpTopContentsIndex

20.1.2 Supported databases

Common SQL supports connections to various databases on the platforms indicated below in . 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 sql:connect :

 

 

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

Oracle

Oracle 10g

:oracle

Windows

Oracle

Oracle 9i (r2) or 10g

:oracle

Solaris

Oracle

Oracle 9i (r2) or 10g

:oracle

HP-UX

Oracle

Oracle 9i (r2) or 10g

:oracle

Linux

Oracle

Oracle

:oracle8

Solaris

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

Linux

MySQL

MySQL

:mysql

FreeBSD

MySQL

MySQL

:mysql

Mac OS X

MySQL

MySQL

:mysql

Windows

MySQL

MySQL

:mysql

Solaris

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: Oracle is not currently (July 2006) available for the Intel based Macintosh.

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 - 11 Mar 2008

NextPrevUpTopContentsIndex