IBM Support

Error: "The ODBC database driver Microsoft Access Driver (*.mdb) is not properly set up on your computer. RequisitePro requires the driver to communicate with this project database."

Troubleshooting


Problem

When trying to open a Oracle® based IBM Rational® RequisitePro® project on a foreign (i.e. not English) operating system, the following error message occurs: "The ODBC database driver Microsoft Access Driver (*.mdb) is not properly set up on your computer. RequisitePro requires the driver to communicate with this project database. Reinstall the ODBC driver using the installation provided with this application, then restart the computer."

Cause

The ODBC driver has been localized on the operating system and RequisitePro cannot find it.

Resolving The Problem

The solution is to indicate to RequisitePro where to find the driver.

Open the file "db_drivers.dat" using Notepad:

ReqPro 7.1: C:\Program Files\IBM\RationalSDLC\RequisitePro\bin\

Versions prior to ReqPro 7.1: C:\Program Files\Rational\RequisitePro\bin\

and change:



"Microsoft ODBC for Oracle"

by the name of the drivers you can see in the Data Sources (ODBC):

"Microsoft ODBC <pour/für/per/voor/...> Oracle"

Two lines must be changed in this file as "Microsoft ODBC for Oracle" is present twice.

Now the .RQL file from the project directory has to be changed as well (or RequisitePro will give a message saying the .RQL file cannot be found).
Go to the project directory and open the .RQL file with Notepad or Wordpad.
If the .RQL file cannot be seen in the folder, it is because it is hidden. In this case, go to Tools > Folder Options > View and select "Show hidden files and folder".

In the .RQL file, change:

"Microsoft ODBC for Oracle"

by the name of the drivers you can see in the Data Sources:

"Microsoft ODBC <pour/für/per/...> Oracle"

Now open again you project.


[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.15;2003.06.16;7.0;7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5;7.0.1;7.0.1.1;7.0.1.2;7.0.1.3;7.0.1.4;7.0.1.5;7.1;7.1.0.1;7.1.0.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21162227