About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
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
Was this topic helpful?
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