Installation guide

mxODBC - Python ODBC Database Interface

Driver = /usr/local/maxdb/lib/libsdbodbcw.so

Description = MaxDB ODBC Driver

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

driver may be different on your system; be sure to use the Unicode

variant which ends with

'…w.so'). It is also necessary to point

LD_LIBRARY_PATH to the directory where the driver itself is located.

[maxdb]

DRIVER = /usr/local/maxdb/lib/libsdbodbcw.so

ServerDB = MYDB

ServerNode = maxdb.example.net

SQLMode =

IsolationLevel =

Trace = 0

TraceFileName=/tmp/maxdb.log

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

connection string such as:

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

4.8.2 General Database Notes

Warnings when deleting/update more than one row at a time

MaxDB issues a mx.ODBC.Error.Warning: ('01001', 0, '[SAP

AG][LIBSDBOD SO] Cursor operation conflict', 8416)

warning whenever

you try to delete or update more than one row with a single database statement.

You can easily work around this by setting the

cursor.warningformat to

IGNORE_WARNINGFORMAT, restoring it afterwards to the default

ERROR_WARNINGFORMAT, if you just want to ignore this particular warning case.

4.9 Teradata

4.9.1 Available ODBC Drivers

Teradata ODBC Driver

Homepage: http://www.teradata.com/downloadcenter/

Tested with Teradata 14.1 ODBC driver and DataDirect 7.1 ODBC manager.

The Teradata ODBC driver was developed by DataDirect and requires the

DataDirect ODBC manager, so you will need to use the

mx.ODBC.DataDirect

package on Unix to work with the driver.