Installation guide

mxODBC - Python ODBC Database Interface

• Unicode data is supported. It works best with the

NATIVE_UNICODE_STRINGFORMAT mode. You can also use the auto-

transcoding feature of mxODBC with UTF-8 as encoding.

• The driver only supports forward scrolling with relative increments of +1.

Other values result in a driver error. As a result, only

cursor.scroll(+1) can be used.

Example Configuration for Unix

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

the driver file may be different on your system):

[ODBC Drivers]

PostgreSQL = Installed

[PostgreSQL]

Description = PostgreSQL ODBC Driver

Driver = /usr/local/postgresql/lib/psqlodbcw.so

Setup =

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

the driver file 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.

[postgresql]

Driver = /usr/local/postgresql/lib/psqlodbcw.so

Database = mydb

ServerName = postgresql.example.net

Port = 5432

#Debug = 0

#Optimizer = 0

#CommLog = 0

#ReadOnly = 0

#SSLmode = require

ByteaAsLongVarBinary = 1

TextAsLongVarchar = 1

# This currently doesn't appear to work:

#UseServerSidePrepare = 1

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

connection string such as:

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

EasySoft ODBC Driver for PostgreSQL

Homepage: http://www.easysoft.com/

OpenLink ODBC Driver for PostgreSQL

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

DataDirect ODBC Driver for PostgreSQL

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