TheDesignspace
ODBC Driver Error: [ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed


September 15, 2011
IIS Management | Troubleshooting | Windows

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:

More after the jump...

Ads by Google


Assume Oracle Client in c:\OraClient folder and web folder as c:\inetpub\wwwroot


  1. c:\inetpub\wwwroot must have Read and Execute privlege for IUSR user.
  2. c:\OraClient must have Read and Execute privlege for IUSR user.
  3. The environment PATH variable must have C:\OraClient\bin included.
  4. Don't forget to restart Web Server

--Many thanks to asnanisatish for summarizing all these solutions.




Posted by ellen at September 15, 2011 12:19 PM | TrackBack

Leave a comment



RSS   |   Contact Me
Ads by Google

Ads by Google