To enable a broker to connect to
a database, define the ODBC data source name (DSN) for the database.
Configure
an ODBC data source using the ODBC Data Source Administrator:
- Click .
- Click the System DSN tab and click Add.
- Complete the steps in the following sections for the databases
that you are working with.
If you need more information about a
particular database product, see the product-specific documentation.
The Default
Configuration wizard and the database commands to create
a broker, or a database, on Windows® automatically
create the ODBC data source names (DSNs) for you.
- DB2® UDB
- To define a data source for DB2 UDB:
- Select the driver IBM DB2 ODBC DRIVER.
- Enter the data source name (DSN) and description.
- Select the correct database alias from the list.
- Click Finish to save your definition.
Click OK to close the ODBC Data
Source Administrator.
You must register the data source as a system data source.If you prefer, you can use the Configuration Assistant
instead of the ODBC Data Source Administrator:
- Open the DB2 Configuration
Assistant.
- Right-click the database. Select Change Database.
- Select Data Source.
- Select Register this database for ODBC.
Select the system data source option.
- Click Finish.
- The Test Connection dialog opens automatically
and you can test the various connections.
- Informix® Dynamic Server
- To define a data source for Informix Dynamic
Server:
- Select the driver IBM INFORMIX ODBC DRIVER.
- On the Connection tab, specify:
- The Informix server name.
- The machine host name.
- The Informix network service
name (as defined in the services file).
- The network protocol (for example, olsotcp).
- The Informix data source
name.
- The user identifier to access the data source within.
- The password for that user identifier.
- Click Apply.
- Click Test Connection to check your supplied
values.
Click OK to close the ODBC Data
Source Administrator.
- Microsoft® SQL Server
- To define a data source for Microsoft SQL
Server:
- Select the driver SQL Server.
The driver level must be Version 3.60, or later.
- Specify a name and description.
- Select the correct server from the list.
- Click Finish to save your definition.
Click OK to close the ODBC Data
Source Administrator.
- Oracle
- To define a data source for Oracle:
- Select the driver MQSeries DataDirect
Technologies 5.00 32-BIT Oracle.
The ODBC
Oracle Driver Setup dialog box opens.
- On the General tab:
- 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 list.
- On the Advanced tab:
- Select Enable SQLDescribeParam.
- Select Procedure Returns Results.
The resultant ODBC definition in the Windows registry has a string value
called ProcedureRetResults with the value 1.
Click OK to close the ODBC Data
Source Administrator.
- Click .
- Type REGEDIT in the Open field
and click OK.
- In the Registry Editor, navigate to the correct
location:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC32.INI
- Expand that location, and right-click your DSN entry. Select .
- Specify WorkArounds for the string name.
- Right-click WorkArounds.
- Select Modify.
- Type the data value 536870912.
- Close the Registry Editor.
- Sybase Adaptive Server Enterprise
- To define a data source for Sybase Adaptive Server Enterprise:
- Select the driver MQSeries DataDirect
Technologies 5.00 32-BIT Sybase Wire Protocol.
- Enter the DSN name, description, and network
address of the server (for a description of the format of this address,
see the explanation for NetworkAddress= in the odbc.ini sample file).
- Select Enable Describe Parameter. This
parameter is on the Advanced tab.
- Ensure the Prepare Method setting is 1
- Partial. This parameter is on the Performance tab.
- Click .
- Type REGEDIT in the Open field
and click OK.
- In the Registry Editor, navigate to the correct
location:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
- Expand that location, and right-click your DSN entry. Select . Specify SelectUserName for
the string, and set the value to 1.
- Close the Registry Editor.
Next: Configure the environment
for issuing console commands, and for running the broker, so that
the broker can access the required database libraries.
For more information, see Setting your environment to support access to databases.