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 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
[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
[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
[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