If you try to connect to an Oracle Database using the Test Connection button in the Data Sources (ODBC) Control Panel, and get the error [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed, try the following suggestions:
Ads by Google
Posted by ellen at September 15, 2011 12:19 PM
Assume Oracle Client in c:\OraClient folder and web folder as c:\inetpub\wwwroot
- c:\inetpub\wwwroot must have Read and Execute privlege for IUSR user.
- c:\OraClient must have Read and Execute privlege for IUSR user.
- The environment PATH variable must have C:\OraClient\bin included.
- Don't forget to restart Web Server
--Many thanks to asnanisatish for summarizing all these solutions.
References
Ads by Google