IBM Support

Unable to connect to the database after upgrading Oracle client on a RequisitePro client system

Troubleshooting


Problem

This technote identifies the resolution to the error, Unable to connect to the database when using IBM® Rational® RequisitePro® fails with a Microsoft® ODBC Driver for Oracle which has recently been upgraded

Cause

The full error message received is as follows:
[Microsoft][ODBC driver for Oracle][Oracle]

-Unable to connect to the database.
-Ensure that the configuration and account information are valid.

One possible cause for this error is that incorrect registry values have been assigned for the Oracle8i or Oracle 9i client at the following registry location:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]

Resolving The Problem

Before performing this solution be sure to test the ODBC connection outside of RequisitePro using the ODBC driver test in technote 1134396.

In most occurrences of this problem the following registry keys are set to values for Oracle7.XX client software which are incompatible with an Oracle8i client installation. The following is an example of the registry settings for an Oracle7 client.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]

"OracleXaLib"="xa73.dll"
"OracleSqlLib"="SQLLib18.dll"
"OracleOciLib"="ociw32.dll"

For the Microsoft ODBC driver for Oracle to work properly the registry settings must be manually modified. Change the registry settings to match the values below which are compatible with the Oracle8i client software:

[HKEY_LOCAL_MACHINES\SOFTWARE\Microsoft\MSDTC\MTxOCI]

"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"

This same problem can occur after upgrading the Oracle client to Oracle 9i. For the Microsoft ODBC driver for Oracle to work properly the registry settings must be manually modified. Change the registry settings to match the values below which are compatible with the Oracle 9i client software:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]

"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"



[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2002.05.00;2002.05.20;2003.06.00;2003.06.01;2003.06.10;2003.06.12;2003.06.13;2003.06.14;2003.06.15","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Historical Number

23996

Document Information

More support for:
Rational RequisitePro

Software version:
2002.05.00, 2002.05.20, 2003.06.00, 2003.06.01, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15

Operating system(s):
Windows

Document number:
76053

Modified date:
16 June 2018

UID

swg21125870

Manage My Notification Subscriptions