WebSphere Message Brokers
File: ah14452_
Writer: Laura Cowen

Reference topic

This build: July 31, 2007 21:30:14

odbc64.ini sample file

A copy of the sample 64-bit ODBC definition file that is supplied with WebSphere Message Broker.

Purpose

Configure the odbc64.ini file when you define an ODBC connection to a database from a 64-bit application. Follow the instructions in Connecting to a database from Linux and UNIX systems: 32-bit considerations.

AIX

[ODBC Data Sources]
WBRKBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 5.0 64bit
Oracle Wire Protocol
SYBASEDB=DataDirect
5.0 64bit Sybase Wire Protocol
SQLSERVERDB=DataDirect
5.0 64bit SQL Server Wire Protocol
[WBRKBKDB]
Driver=libdb2Wrapper64.so
Description=WBRKBKDB DB2 ODBC Database
Database=WBRKBKDB
[MYDB]
Driver=libdb2Wrapper64.so
Description=MYDB DB2 ODBC Database
Database=MYDB
[ORACLEDB]
Driver=<Your install directory>/DD64/lib/UKora20.so
Description=DataDirect 5.0 Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
SID=<Your Oracle SID>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
[SYBASEDB]
Driver=<Your install directory>/DD64/lib/UKase20.so
Description=DataDirect 5.0 Sybase Wire Protocol
Database=<Your Database Name>
ApplicationsUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<YourServerName>,<YourPortNumber>
SelectUserName=1
[SQLSERVERDB]
Driver=<Your install directory>/DD64/lib/UKmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=<Your SQLServer host>,<your SQLServer server port>
AnsiNPW=Yes
Database=<Your Database Name>
QuoteId=No
[ODBC]
Trace=0
TraceFile=<A Directory with plenty of free space>/odbctrace.out
TraceDll=<Your install directory>/DD64/lib/odbctrac.so
InstallDir=<Your install directory>/DD64
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

HP-UX (PA-RISC platform)

[ODBC Data Sources]
WBRKBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 5.0 64bit
Oracle Wire Protocol
SYBASEDB=DataDirect
5.0 64bit Sybase Wire Protocol
SQLSERVERDB=DataDirect
5.0 64bit SQL Server Wire Protocol
[WBRKBKDB]
Driver=libdb2Wrapper64.sl
Description=WBRKBKDB DB2 ODBC Database
Database=WBRKBKDB
[MYDB]
Driver=libdb2Wrapper64.sl
Description=MYDB DB2 ODBC Database
Database=MYDB
[ORACLEDB]
Driver=<Your install directory>/DD64/lib/UKora20.sl
Description=DataDirect 5.0 Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name
PortNumber=<Port on which Oracle is listening on HostName
SID=<Your Oracle SID>
CatalogOptions=0
ProcedureRetResults=1
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ColumnSizeAsCharacter=1
[SYBASEDB]
Driver=<Your install directory>/DD64/lib/UKase20.sl
Description=DataDirect 5.0 Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<YourServerName>,<YourPortNumber>
SelectUserName=1
[SQLSERVERDB]
Driver=<Your install directory>/DD64/lib/UKmsss20.sl
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=<Your SQLServer host>,<your SQLServer server port>
AnsiNPW=Yes
Database=<Your Database Name>
QuoteId=No
[ODBC]
Trace=0
TraceFile=<A Directory with plenty of free space>/odbctrace.out
TraceDll=<Your install directory>/DD64/lib/odbctrac.sl
InstallDir=<Your install directory>/DD64
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

HP-UX (Integrity platform)

[ODBC Data Sources]
WBRKBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 5.0 64bit
Oracle Wire Protocol
[WBRKBKDB]
Driver=libdb2Wrapper.so
Description=WBRKBKDB DB2 ODBC Database
Database=WBRKBKDB
[MYDB]
Driver=libdb2Wrapper.so
Description=MYDB DB2 ODBC Database
Database=MYDB
[ORACLEDB]
Driver=<Your install directory>/DD64/lib/UKora20.so
Description=DataDirect 5.0 Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name
PortNumber=<Port on which Oracle is listening on HostName
SID=<Your Oracle SID>
CatalogOptions=0
ProcedureRetResults=1
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ColumnSizeAsCharacter=1
[ODBC]
Trace=0
TraceFile=<A Directory with plenty of free space>/odbctrace.out
TraceDll=<Your install directory>/DD64/lib/odbctrac.so
InstallDir=<Your install directory>/DD64
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Solaris (SPARC platform)

[ODBC Data Sources]
WBRKBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 5.0 64bit
Oracle Wire Protocol
SYBASEDB=DataDirect
5.0 64bit Sybase Wire Protocol
SQLSERVERDB=DataDirect
5.0 64bit SQL Server Wire Protocol
[WBRKBKDB]
Driver=libdb2Wrapper64.so
Description=WBRKBKDB DB2 ODBC Database
Database=WBRKBKDB
[MYDB]
Driver=libdb2Wrapper64.so
Description=MYDB DB2 ODBC Database
Database=MYDB
[ORACLEDB]
Driver=<Your install directory>/DD64/lib/UKor820.so
Description=DataDirect 5.0 Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name
PortNumber=<Port on which Oracle is listening on HostName
SID=<Your Oracle SID>
CatalogOptions=0
ProcedureRetResults=1
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ColumnSizeAsCharacter=1
[SYBASEDB]
Driver=<Your install directory>/DD64/lib/UKase20.so
Description=DataDirect 5.0 Sybase Wire Protocol
Database=<Your Database Name>
ServerName=<YourServerName>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<YourServerName>,<YourPortNumber>
SelectUserName=1
[SQLSERVERDB]
Driver=<Your_install_directory>/merant/lib/UKmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=<Your SQLServer host>,<Your SQLServer server port>
AnsiNPW=Yes
Database=<Your Database Name>
QuoteId=No
[INFORMIXDB]
Driver=<Your Informix Client Directory>/lib/cli/iclit09b.so
Description=IBM Informix ODBC Driver
ServerName=<YourServerName>
Database=<Your Database Name>
[ODBC]
Trace=0
TraceFile=<A Directory with plenty of free space>/odbctrace.out
TraceDll=<Your_install_directory>/merant/lib/odbctrac.so
InstallDir=<Your_install_directory>/merant
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8
Related tasks
Connecting to a database from Linux and UNIX systems: 32-bit considerations
Connecting to a database from Linux and UNIX systems
Related reference
Supported databases
odbc.ini sample file
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:30:14

ah14452_ This topic's URL is: