Installation guide

14. mx.ODBC Driver/Manager Packages
14.3.2 Supported Datatypes
The subpackage defaults to SQL type binding mode (see the Datatypes section for
details), but reverts to Python type binding in case the connection does not
support the ODBC SQLDescribeParam() API. MS Access is one candidate for
which this API is not useable.
14.3.3 File Data Sources
If you want to connect to a file data source (without having to configure it using
the ODBC manager), you can do so by using the FILEDSN= parameter instead of
the DSN= parameter:
DriverConnect('FILEDSN=test.dsn;UID=test;PWD=test')
This is sometimes useful when you want to dynamically setup a data source, e.g. a
MS Access database.
For more information about the FILEDSN-keyword and the other Windows ODBC
manager features, see the Microsoft SQLDriverConnect() documentation
.
Also note that ODBC drivers working on single files, e.g. the MS Excel file driver,
usually do not support transactions. mxODBC will not clear auto-commit for
these drivers (it may sometimes still be necessary to set the
clear_auto_commit
flag in the connect constructors to 0).
14.4 mx.ODBC.iODBC --
Manager
iODBC Driver
Tested with iODBC 3.52.7.
iODBC is an Open Source ODBC manager for Unix maintained by OpenLink. It
compiles against mxODBC without problems and is the preferred way of talking
to an ODBC data source from Unix using mxODBC.
14.4.1 Notes
General Recommendations
• Please always use the DriverConnect() API to connect to the data
source if you need to pass in extra configuration information such as
names of log files, etc.
175