Troubleshooting
Problem
This technote identifies a resolution to the error, Driver's SQLAllocHandle on SQL_HANDLE_ENV Failed - Unable to connect to datasource, which might occur when IBM® Rational® RequisitePro® RequisiteWeb attempts to open an Oracle based project.
Symptom
The full error message is:
ODBC Error: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV Failed - Unable to connect to datasource
Cause
This error has been known to occur when the user that performed the installation of Oracle 9i or 10G did not have the correct permissions to complete the installation successfully.
Resolving The Problem
To resolve this issue perform the following procedure:
- Navigate to Oracleora92 or Oracle10g Home directory
- Right click the Home directory and select Properties
- Select the Security tab
- Ensure the ReqPro User is listed and has the following permissions:
- Read and Execute
- Read
- Select Advanced and check the: Replace permission entries on all child objects with entries shown here that apply to child objects, option
- Click OK in the Advanced Security Settings dialog box
- Click OK in the Properties dialog box
- Restarted RequisiteWeb server
[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database: Oracle","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.0.6;7.0.0.7;7.0.0.8;7.0.1;7.0.1.1;7.0.1.2;7.0.1.3;7.0.1.4;7.0.1.5;7.0.1.6;7.0.1.7;7.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21254800