Here are the operative portions of
[ODBC Data Sources] dsn_oracle = OpenLink Generic ODBC Driver [ODBC] ;DebugFile= /tmp/odbc.out [Communications] ReceiveTimeout = 120 BrokerTimeout = 30; RetryTimeout = 5 SendSize= 4096 ReceiveSize = 16000 ShowErrors= Y DataEncryption = N [dsn_oracle] Driver = /usr/openlink/lib/oplodbc.so Description = Sample Oracle DSN Host = openlinux.openlinksw.com ServerType = Oracle 8.1.x FetchBufferSize = 60 Database = ORCL DeferLongFetch = Options = UserName = scott Password = tiger ReadOnly = yes Trace = 1 TraceFile = /tmp/trace.out
Here is a description of important sections that appear within odbc.ini:
ODBC Data Sources
The [ODBC Data Sources] section contains a listing of Data Source Names paired with drivers. The Data Source Name is the value that appears on the left. (The actual Data Source should appear later in the file. When it does appear, the name will be enclosed in square brackets. Individual connection parameters and values will appear under the bracketed heading.) The driver name is the value on the right. It should match an entry in the odbcinst.ini file.
Note: Data Source Names do not need to appear in the list. However, programs like odbctest will not return an complete list of Data Source Names, if they are not registered under [ODBC Data Sources]
ODBC
The ODBC section contains the
Users must place a semicolon in front of
Communications
The Communications section contains timeout and other sections that affect
DSN
The individual [dsn] sections pass the connection attributes that enable the driver to connect to a target database. Here is a description of each of the attributes:
Note: Insure that no spaces precede the DSN name or its individual parameters.
Spaces preceding DSN names or parameters are associated with connectivity problems.