A copy of the sample 32-bit ODBC definition file that is supplied with WebSphere® Event Broker.
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle SYBASEDB=DataDirect 5.0 Sybase Wire Protocol SQLSERVERDB=DataDirect 5.0 SQL Server Wire Protocol INFORMIXDB=IBM Informix ODBC Driver
[WBRKBKDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.a Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.a Description=MYDB DB2 ODBC Database Database=MYDB
[ORACLEDB]
Driver=<Your_install_directory>/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=<Your Oracle host>
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
[SYBASEDB] Driver=<Your_install_directory>/merant/lib/UKase20.so Description=DataDirect 5.0 Sybase Wire Protocol Database=<Your Database Name> ServerName=<Your Server Name> 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 Driver Address=<Your SQLServer Host>,<Your SQLServer server port> Database=<Your Database Name> AnsiNPW=Yes QuoteId=No
# Informix stanza [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
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle SYBASEDB=DataDirect 5.0 Sybase Wire Protocol SQLSERVERDB=DataDirect 5.0 SQL Server Wire Protocol INFORMIXDB=IBM Informix ODBC Driver
[WBRKBKDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.sl Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.sl Description=MYDB DB2 ODBC Database Database=MYDB
# Oracle stanza
[ORACLEDB]
Driver=<Your_install_directory>/merant/lib/UKor820.sl
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=<Your Oracle Host>
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
[SYBASEDB] Driver=<Your_install_directory>/merant/lib/UKase20.sl Description=DataDirect 5.0 Sybase Wire Protocol Database=<Your Database Name> ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 SelectMethod=0 NetworkAddress=<YourServerName>,<YourPortNumber> SelectUserName=1
[SQLSERVERDB] Driver=<Your_install_directory>/merant/lib/UKmsss20.sl Description=DataDirect 5.0 SQL Server Wire Protocol Address=<Your SQLServer host>,<Your SQLServer server port> Database=<Your Database Name> AnsiNPW=Yes QuoteId=No
[INFORMIXDB] Driver=<Your Informix Client Directory>/lib/cli/iclit09b.sl 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.sl InstallDir=<Your_install_directory>/merant UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle SYBASEDB=DataDirect 5.0 Sybase Wire Protocol SQLSERVERDB=DataDirect 5.0 SQL Server Wire Protocol INFORMIXDB=IBM Informix ODBC Driver
[WBRKBKDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.so Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.so Description=MYDB DB2 ODBC Database Database=MYDB
[ORACLEDB] Driver=<Your_install_directory>/merant/lib/UKor820.so Description=DataDirect 5.0 Oracle EnableDescribeParam=1 OptimizePrepare=1 ServerName=<Your Oracle Host> WorkArounds=536870912 ProcedureRetResults=1 ColumnSizeAsCharacter=1
[SYBASEDB]
Driver=<Your_install_directory>/merant/lib/UKase20.so
Description=DataDirect 5.0 Sybase Wire Protocol
Database=<Your Database Name>
ServerName=<YourServerName>
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>
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>/merant/lib/odbctrac.so InstallDir=<Your_install_directory>/merant UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle SYBASEDB=DataDirect 5.0 Sybase Wire Protocol SQLSERVERDB=DataDirect 5.0 SQL Server Wire Protocol INFORMIXDB=IBM Informix ODBC Driver
[WBRKBKDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.so Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.so Description=MYDB DB2 ODBC Database Database=MYDB
[ORACLEDB]
Driver=<Your_install_directory>/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
ProcedureRetResults=1
ServerName=<Your Oracle Host>
WorkArounds=536870912
OptimizePrepare=1
ColumnSizeAsCharacter=1
[SYBASEDB] Driver=<Your_install_directory>/merant/lib/UKase20.so Description=DataDirect 5.0 Sybase Wire Protocol Database=<Your Database Name> ServerName=<YourServerName> 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> 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>/merant/lib/odbctrac.so InstallDir=<Your_install_directory>/merant UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle Wire Protocol SYBASEDB=DataDirect 5.0 Sybase Wire Protocol
[WBRKBKDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.so Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=<Your_DB2_installation_directory>/lib/libdb2.so Description=MYDB DB2 ODBC Database Database=MYDB
[ORACLEDB]
Driver=<Your_install_directory>/merant/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
EnableDescribeParam=1
ProcedureRetResults=1
WorkArounds=536870912
OptimizePrepare=1
ColumnSizeAsCharacter=1
[SYBASEDB] Driver=<Your_install_directory>/merant/lib/UKase20.so Description=DataDirect 5.0 Sybase Wire Protocol Database=<Your Database Name> ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 SelectMethod=0 NetworkAddress=<YourServerName>,<YourPortNumber> SelectUserName=1
[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