LispWorks User Guide and Reference Manual > 19 Common SQL > 19.1 Introduction

NextPrevUpTopContentsIndex

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

NextPrevUpTopContentsIndex