Configure an ODBC data source using the ODBC Data Source Administrator.
Select , and select the System
DSN tab. When you define a new data source, select the appropriate
driver for your database and complete the dialog that is displayed. Refer
to your relevant database product documentation for more information.
Setup
considerations specific to WebSphere Message Broker are
described below for the supported databases.
- DB2 UDB
- When you define a data source for DB2 UDB you must choose the
driver named IBM DB2 ODBC DRIVER. Enter the data source name
(DSN) and description, and select the correct database alias from the drop-down
list. You must register the data source as a system data source.
You
might find it easier to use the Configuration Assistant:
- Open the DB2 Configuration Assistant.
- Right-click the database, and select Change Database.
- Select Data Source.
- Select Register this database for ODBC and select
the system data source option.
- Click Finish.
- The Test Connection dialog opens automatically
and you can test the various connections.
- Microsoft SQL Server
- When you define a data source for Microsoft SQL Server you must choose
the driver named SQL Server. The driver level must be Version
3.60 or later. Specify a name and description, and select the correct server
from the drop-down list.
- Oracle
- When
you define a data source for Oracle, choose the driver:
- MQSeries DataDirect Technologies 5.00 32-BIT Oracle
Complete these steps to configure the driver:
- Enter the DSN name, description, and server name (where the server name
is the "Service Name" that resolves to a "Connect Descriptor", for example
through a mapping in the TSNAMES.ORA file).
- Select the appropriate Oracle client version
from the drop-down list.
- Ensure that the Enable SQLDescribeParam box is
checked. This parameter is on the Advanced tab of the
driver settings.
- Create a new registry subkey for each of your DSNs that reference an Oracle
database. Use REGEDIT to navigate to the correct location:
HKEY_LOCAL_MACHINE
SOFTWARE
ODBC
ODBC.INI
- Right-click the DSN, and select . Specify WorkArounds for
the string, and set the value to 536870912.
- Sybase Adaptive Server Enterprise
- When you define a data source for Sybase Adaptive Server Enterprise,
choose the driver:
- MQSeries DataDirect Technologies 5.00 32-BIT Sybase Wire Protocol
Complete these steps to configure the driver:
- Enter the DSN name, description, network address of the server (for a
description of the format of this address, see the explanation for NetworkAddress= in ODBC.ini Parameters).
- Ensure the Enable Describe Parameter box is checked.
This parameter is on the Advanced tab.
- Ensure the Prepare Method setting is 1
- Partial. This parameter is on the Performance tab.