Installation guide

mxODBC - Python ODBC Database Interface

• The MySQL ODBC driver does not always update the

.rownumber to the

correct value, especially when using

.scroll(). For client side cursors,

mxODBC corrects this using an emulation for

.rownumber.

• When using the ODBC driver RPMs available from www.mysql.com

please be sure to also have the MySQL shared libs RPM and the MySQL

development RPM installed.

• Some older MySQL + ODBC driver setups eGenix.com has tested

showed some serious memory leaks on Linux machines. Please check

your setup for such leaks before going into production. There are no

known leaks in mxODBC itself.

Example Configuration for Unix

• Add a MySQL driver section to the ~/.odbcinst.ini file (the location of the

driver file may be different on your system):

[ODBC Drivers]

MySQL = Installed

[MySQL]

Description = MySQL ODBC Driver

Driver = /usr/local/lib/libmyodbc5w.so

Setup =

• Edit the ~/.odbc.ini file based and add a mysql section(the location of

the driver file may be different on your system). It is also necessary to

point LD_LIBRARY_PATH to the directory where the driver itself is

located.

[myodbc]

Driver = /usr/local/lib/libmyodbc5w.so

Description = MySQL 5 Server

Server = mysql.example.net

Port =

# Specifying a database is necessary for MySQL, since you'll

# otherwise won't be able to connect

Database = mydb

# Allow big packets for BLOBs, etc.

option = 8

#Socket =

• Using these settings, you can then connect to MySQL using a simple

connection string such as:

"DSN=mysql;UID=username;PWD=password"

OpenLink ODBC Driver for MySQL

Homepage: http://www.openlinksw.com/

DataDirect ODBC Driver for MySQL

Homepage: http://www.datadirect.com/