Configuring odbc.ini for UNIX Users
Although Microsoft Windows users do not use an odbc.ini file, UNIX users do. A sample odbc.ini file is shown below for use when connecting to any of the supported Wire Protocols using a UNIX system. Instances of the term "DataDirect" are replaced with the term "IBM Lotus OEM" in the .ini file.
DB2 Wire Protocol=IBM Lotus OEM 5.3 DB2 Wire Protocol Driver
dBase=IBM Lotus OEM 5.3 dBaseFile(*.dbf)
FoxPro3=IBM Lotus OEM 5.3 dBaseFile(*.dbf)
Informix=IBM Lotus OEM 5.3 Informix
Informix Wire Protocol=IBM Lotus OEM 5.3 Informix Wire Protocol
Oracle=IBM Lotus OEM 5.3 Oracle
Oracle Wire Protocol=IBM Lotus OEM 5.3 Oracle Wire Protocol
SQLServer Wire Protocol=IBM Lotus OEM 5.3 SQL Server Wire Protocol
Sybase Wire Protocol=IBM Lotus OEM 5.3 Sybase Wire Protocol
MySql Wire Protocol=IBM Lotus OEM 5.3 MySql Wire Protocol
Text=IBM Lotus OEM 5.3 TextFile(*.*)
[DB2 Wire Protocol]
Driver=/opt/odbc/lib/LOdb223.so
Description=IBM Lotus OEM 5.3 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390 and AS/400 (leave blank for DB2 UDB)
Database=DB2 UDB (leave blank for OS/390 and AS/400)
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=DB2 server host
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400 (leave blank for DB2 UDB)
LogonID=UID
password=PWD
Package=DB2 package name
PackageOwner=
TcpPort=DB2 server port
WithHold=1
[DB2V71]
Driver=/opt/odbc/lib/LOdb223.so
Description=IBM Lotus OEM 5.3 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Database=DB2V71
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=rage
IsolationLevel=CURSOR_STABILITY
LogonID=UID
password=PWD
Package=DDODBC
PackageOwner=
TcpPort=50000
WithHold=1
[Informix Wire Protocol]
Driver=/opt/odbc/lib/LOifcl23.so
Description=IBM Lotus OEM 5.3 Informix Wire Protocol
ApplicationUsingThreads=1
CancelDetectInterval=0
Database=db
HostName=Informix host
LogonID=UID
password=PWD
PortNumber=Informix server port
ServerName=Informix server
TrimBlankFromIndexName=1
[InformixDSN]
Driver=/opt/odbc/lib/LOifcl23.so
Description=IBM Lotus OEM 5.3 Informix Wire Protocol
ApplicationUsingThreads=1
CancelDetectInterval=0
Database=qetest
HostName=flood
LogonID=UID
password=PWD
PortNumber=1526
ServerName=informix_940
TrimBlankFromIndexName=1
[Oracle Wire Protocol]
Driver=/opt/odbc/lib/LOora23.so
Description=IBM Lotus OEM 5.3 Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=Oracle server
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=UID
password=PWD
PortNumber=1521
ProcedureRetResults=0
SID=Oracle SID
UseCurrentSchema=1
[ODBCToOracle10]
Driver=/opt/odbc/lib/LOora23.so
Description=IBM Lotus OEM 5.3 Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=flood
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=UID
password=PWD
PortNumber=1521
ProcedureRetResults=0
SID=flood
UseCurrentSchema=1
[SQLServer Wire Protocol]
Driver=/opt/odbc/lib/LOmsss23.so
Description=IBM Lotus OEM 5.3 SQL Server Wire Protocol
Address=SQLServer host,SQLServer server port
AnsiNPW=Yes
Database=db
LogonID=UID
password=PWD
QuotedId=No
[ODBCToSQLServer7]
Driver=/opt/odbc/lib/LOmsss23.so
Description=IBM Lotus OEM 5.3 SQL Server Wire Protocol
Address=frost,1433
AnsiNPW=Yes
Database=Tracey
LogonID=UID
password=PWD
QuotedId=No
[Sybase Wire Protocol]
Driver=/opt/odbc/lib/LOase23.so
Description=IBM Lotus OEM 5.3 Sybase Wire Protocol
ApplicationName=
ApplicationUsingThreads=1
ArraySize=50
Charset=
CursorCacheSize=1
Database=db
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EnableQuotedIdentifiers=0
InitializationString=
Language=
LogonID=UID
NetworkAddress=Sybase host,Sybase server port
OptimizePrepare=1
PacketSize=0
password=PWD
RaiseErrorPositionBehavior=0
SelectMethod=0
WorkStationID=
[ODBCTOSybase15]
Driver=/opt/odbc/lib/LOase23.so
Description=IBM Lotus OEM 5.3 Sybase Wire Protocol
ApplicationName=
ApplicationUsingThreads=1
ArraySize=50
Charset=
CursorCacheSize=1
Database=SILK_DATA
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EnableQuotedIdentifiers=0
InitializationString=
Language=
LogonID=UID
NetworkAddress=frost,5000
OptimizePrepare=1
PacketSize=0
password=PWD
RaiseErrorPositionBehavior=0
SelectMethod=0
WorkStationID=
[MySQL Wire Protocol]
Driver=/opt/odbc/lib/LOmysql23.so
Description=DataDirect 5.3 MySQL Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=<database_name>
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
HostName=<MySQL_host>
InteractiveClient=0
LicenseNotice=You must purchase commercially licensed MySQL database software or a MySQL Enterprise subscription in order to use the DataDirect Connect for ODBC for MySQL Enterprise driver with MySQL software.
LoadBalancing=0
LogonID=
Password=
PortNumber=<MySQL_server_port>
ReportCodepageConversionErrors=0
TreatBinaryAsChar=0
[odbctomysql5]
Driver=/opt/odbc/lib/LOmysql23.so
Description=IBM Lotus OEM 5.3 MySQL Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=qepump
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
HostName=python.lab.in.ibm.com
InteractiveClient=0
LicenseNotice=You must purchase commercially licensed MySQL database software or a MySQL Enterprise subscription in order to use the DataDirect Connect for ODBC for MySQL
Enterprise driver with MySQL software.
LoadBalancing=0
LogonID=UID
Password=PWD
PortNumber=3306
ReportCodepageConversionErrors=0
TreatBinaryAsChar=0
[ODBC]
IANAAppCodePage=4
InstallDir=/opt/odbc
Trace=0
TraceDll=/opt/odbc/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0