WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
Enabling ODBC connections to the databases
Set up the resources and environment that the broker requires for Open Database Connectivity (ODBC) connections to user databases on distributed systems.
You can configure both ODBC and Java™ Database Connectivity (JDBC) connections for access to user databases:
- To set up ODBC connections to user databases, follow the instructions in this section.
Optionally, after configuring the ODBC connection parameters, run the mqsicvp command to verify that the broker can connect to the data source, and to provide useful information about the data source and its interface. On Linux and UNIX systems, this command also checks that the ODBC environment is set up correctly.
- To set up JDBC connections to user databases, see Enabling JDBC connections to the databases.
- On z/OS® systems, see Data sources on z/OS for information about enabling connections to databases. You do not have to follow the tasks that are described in this section.
- On Linux and UNIX systems, unixODBC is the supported driver manager and is installed by default as part of the WebSphere® Message Broker ODBC Database Extender SupportPac. The SupportPac is automatically installed in silent mode when the installation of the WebSphere Message Broker component completes. For more information, see Installing the WebSphere Message Broker ODBC Database Extender. DataDirect database drivers continue to be used by the unixODBC driver manager when interfacing with Oracle, Sybase, and SQLServer databases.
- On Windows, Linux and UNIX systems, WebSphere Message Broker Version 8.0 ships with the DataDirect V6.0 ODBC drivers. From Fix Pack Version 8.0.0.2 onwards, the DataDirect V7.0 ODBC drivers are shipped in addition to the default V6.0 ODBC drivers. From Fix Pack Version 8.0.0.6 onwards, the DataDirect V7.0 ODBC drivers are replaced by the V7.1 ODBC drivers. If required, WebSphere Message Broker can be switched to using the DataDirect V7.x ODBC drivers. For more information, see Switching WebSphere Message Broker to use the DataDirect V7 drivers.
- On Linux and UNIX systems, delete the ODBCINI64 environment variable if it exists; it is not required by WebSphere Message Broker Version 8.0. For more information, see User database connections. The sample odbc.ini and odbcinst.ini files that are supplied, and the information that is contained in these configuration topics, include all the connection parameters that are supported for connections to your databases. Any additional parameters that are provided by your chosen database drivers are not tested or supported in a broker environment; consider your requirements carefully before specifying other parameters in your tailored ODBC .ini files.
To enable connections on distributed systems:
Define the ODBC DSNs according to your platform:
On Windows:
- Follow the instructions in Connecting to a database from Windows systems.
On Linux and UNIX systems:
- For all supported databases, follow the instructions in Connecting to a database from Linux and UNIX systems by using the WebSphere Message Broker ODBC Database Extender.
You have now enabled the broker to make
connections to your user databases.
Next: If you have been using
the instructions in Working with databases, the next task
is Configuring ODBC connections for globally coordinated transactions (optional).