Puzzling this one. I need to connect Enterprise Architect to an ODBC data source so I can reverse engineer some tables into a diagram. Already lost a day on dicking about with the Oracle Client.
The error I am getting is :
"Unable to connect
SQL State = IM004
[Microsoft][ODBC Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed."
Popular solutions online include
1) Setting an environment variable for ORACLE_HOME. Done this.
2) Changing the folder permissions on the client_1 directory (and subfolders and child objects) to include read and execute permissions. Done this. Even added "Everyone" with full control out of desperation.
3) Adding the client_1 and client_1\bin directories to the path and trying in varying positions along the path string. Done this.
I am using Windows XP Service Pack 3.
I am using Oracle 11.2.0 client.
The version of sqora32.dll is 11.2.0.3
The error I am getting is :
"Unable to connect
SQL State = IM004
[Microsoft][ODBC Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed."
Popular solutions online include
1) Setting an environment variable for ORACLE_HOME. Done this.
2) Changing the folder permissions on the client_1 directory (and subfolders and child objects) to include read and execute permissions. Done this. Even added "Everyone" with full control out of desperation.
3) Adding the client_1 and client_1\bin directories to the path and trying in varying positions along the path string. Done this.
I am using Windows XP Service Pack 3.
I am using Oracle 11.2.0 client.
The version of sqora32.dll is 11.2.0.3
Comment