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