NextPrevUpTopContentsIndex

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

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

:oracle8

Solaris

Oracle

Oracle

:oracle8

HP-UX

Oracle

Oracle

:oracle8

Tru64 UNIX

Oracle

Oracle

:oracle8

Linux

PostgreSQL

Postgres

:postgresql

Mac OS X

PostgreSQL

Postgres

:postgresql

Windows

PostgreSQL

Postgres

:postgresql

Note: MySQL needs to 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.


LispWorks User Guide - 8 Apr 2005

NextPrevUpTopContentsIndex