Installation guide

3. Access Databases using mxODBC
iODBC needs this section in the odbc.ini file. unixODBC in the odbcinst.ini
file. More recent DataDirect ODBC manager versions accept the section in
both files, older version need it in the odbc.ini file.
[ODBC Data Sources]
This section contains one entry per configured data source, mapping the data
source name to a description.
Example:
[ODBC]
Trace = 0
TraceFile = /tmp/odbc.log
[ODBC Data Sources]
sybasease12 = Sybase ASE 12 on sybasease12.example.net
[sybasease12]
Driver = /opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
Description = Adaptive Server Enterprise
Server = sybasease12.egenix.internal
Port = 5000
Database = mydb
TextSize = 10000000
#UseCursor = 1
FileUsage = -1
Trace = 0
TraceFile = /tmp/sybase.log
~/.odbc.ini - User ODBC Data Source Configuration
This INI-file provides data source information on a per user basis. It uses the same
structure as the system wide /etc/odbc.ini file.
The data sources defined in this file are only visible to the user account for which
it is defined.
/etc/odbcinst.ini - System ODBC Driver 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/odbcinst.ini.
This INI-file provides one INI-section per installed ODBC driver.
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.
27