Installation guide

4. Accessing Popular Databases

Actual Technologies Mac OS X ODBC Driver for MySQL

Homepage: http://www.actualtech.com/

When using the driver on Mac OS X 10.6 (Snow Leopard), be sure to use version

3.0.9 or higher, since earlier versions had a problem with fetching data.

4.7.2 General Notes

Depending on whether you use a transactional MySQL storage backend or not,

clearing the auto-commit flag at connection time, which is normally done per

default by the connection constructors, will not work.

Be sure to set

clear_auto_commit=0 if you know that the storage backend

cannot handle transactions. mxODBC will then default to auto-commit mode.

Rollback will not work in that mode.

4.8 SAP MaxDB / SAPDB

4.8.1 Available ODBC Drivers

MaxDB ODBC driver

Homepage: http://www.sdn.sap.com/irj/sdn/maxdb

Tested with MaxDB 7.7 ODBC driver

MaxDB ships with ODBC drivers for all supported platforms. The ODBC driver is

included in the distribution tar archive of the database as SDBODBC.TGZ.

You can use the drivers with both unixODBC and iODBC.

Note that the MaxDB 7.7 ODBC driver can also connect to a MaxDB 7.6 database

server. It is usually best to use the latest available version, even if your database

servers hasn't been upgraded yet.

Example Configuration for Unix

• Edit your ~/.odbcinst.ini file and add the MaxDB driver (the location of

the driver and setup file may be different on your system):

[ODBC Drivers]

MaxDB = Installed

[MaxDB]