Installation guide

mxODBC - Python ODBC Database Interface

The GUI tools can typically be found in the System part of the menu.

For more details description please see the ODBC manager manuals:

• unixODBC User Manual

• iODBC User Manual

• DataDirect User Manual

• Mac OS X ODBC Administrator Manual

Since the layout and operation of these tools is often similar to the Windows

ODBC manager, you can also have a look at the Windows ODBC documentation

for details.

Starting the ODBC manager will bring up a dialog with tabs for data source

creation, ODBC tracing and connection pooling as well as a few information tabs

showing the versions of installed drivers.

3.3.5 ODBC Configuration Files

On Windows, you should always use the Windows ODBC Manager to configure

ODBC data sources.

Even though the Windows ODBC Manager also exposes the standard ODBC

configuration files C:\Windows\ODBC.INI and C:\Windows\ODBCINST.INI, these

do not contain the full configuration information, since this is stored in the

Windows registry.

/etc/odbc.ini - System ODBC Data Source Configuration

Depending on your ODBC manager installation or OS, the file may also reside in a

different directory. Please consult your ODBC manager documentation for details.

On Mac OS X, the file is located in /Library/ODBC/odbc.ini.

This INI-file provides data source information using one INI-section per data

source.

In addition to the data source sections, there are also a number of higher-level

sections:

[ODBC]

This section is used to configure driver related ODBC manager settings such as

ODBC call tracing. The settings in this section apply to all data sources.

For Mac OS X 10.6 (Snow Leopard) you may have to install the ODBC Administrator

separately. It is available from Apple as disk image: http://support.apple.com/kb/DL895