A copy of the sample 64-bit ODBC definition file that is supplied with WebSphere® Message Broker.
[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 64bit 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 64bit 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.so Description=DataDirect 5.0 64bit SQL Server Wire Protocol Address=<Your SQL Server host>,<Your SQL Server server port> Database=<Your Database Name> AnsiNPW=Yes 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
[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 64bit 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.sl Description=DataDirect 5.0 64bit 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 64bit SQL Server Wire Protocol Address=<Your SQL Server host>,<Your SQL Server server port> Database=<Your Database Name> AnsiNPW=Yes 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
[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 64bit 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
[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
[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 64bit 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 64bit 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.so. Description=DataDirect 5.0 64bit SQL Server Wire Protocol Address=<Your SQL Server host>,<Your SQL Server server port> Database=<Your Database Name> AnsiNPW=Yes 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>/DD64DD64/lib/odbctrac.so InstallDir=<Your install directory>/DD64 UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8