LOTUS CONNECTORS

Configuring odbc.ini for UNIX Users
Although Win32 users do not use an odbc.ini file, 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 "Data Direct" are replaced with the term "IBM Lotus OEM" in the .ini file.

[ODBC Data Sources]

DB2 Wire Protocol=IBM Lotus OEM 5.2 DB2 Wire Protocol Driver

dBase=IBM Lotus OEM 5.2 dBaseFile(*.dbf)

FoxPro3=IBM Lotus OEM 5.2 dBaseFile(*.dbf)

Informix=IBM Lotus OEM 5.2 Informix

Informix Wire Protocol=IBM Lotus OEM 5.2 Informix Wire Protocol

Oracle=IBM Lotus OEM 5.2 Oracle

Oracle Wire Protocol=IBM Lotus OEM 5.2 Oracle Wire Protocol

Progress9=IBM Lotus OEM 5.2 Progress9

Progress10=IBM Lotus OEM 5.2 Progress10

SQLServer Wire Protocol=IBM Lotus OEM 5.2 SQL Server Wire Protocol

Sybase Wire Protocol=IBM Lotus OEM 5.2 Sybase Wire Protocol

Text=IBM Lotus OEM 5.2 TextFile(*.*)

[DB2 Wire Protocol]

Driver=/opt/odbc/lib/LOdb220.so

Description=IBM Lotus OEM 5.2 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/LOdb220.so

Description=IBM Lotus OEM 5.2 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/LOifcl20.so

Description=IBM Lotus OEM 5.2 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/LOifcl20.so

Description=IBM Lotus OEM 5.2 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/LOora20.so

Description=IBM Lotus OEM 5.2 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/LOora20.so

Description=IBM Lotus OEM 5.2 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/LOmsss20.so

Description=IBM Lotus OEM 5.2 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/LOmsss20.so

Description=IBM Lotus OEM 5.2 SQL Server Wire Protocol

Address=frost,1433

AnsiNPW=Yes

Database=Tracey

LogonID=UID

password=PWD

QuotedId=No

[Sybase Wire Protocol]

Driver=/opt/odbc/lib/LOase20.so

Description=IBM Lotus OEM 5.2 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=

[ODBCTOSybase12]

Driver=/opt/odbc/lib/LOase20.so

Description=IBM Lotus OEM 5.2 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=

[ODBC]

IANAAppCodePage=4

InstallDir=/opt/odbc

Trace=0

TraceDll=/opt/odbc/lib/odbctrac.so

TraceFile=odbctrace.out

UseCursorLib=0