Had the same error when hosting .asp website that was making a connection to an Oracle database using the ODBC driver on Windows 2016 server. Found the below steps on a site. Couldn’t paste the link so I copied the steps.
This can occur if you have an invalid or incorrect PATH variable. To check your PATH variable:
Locate the PATH variable and copy it"s contents to a text editor such as notepad
Once you have done this you should now look for the following:
A missing semicolon between the different application paths. Each application path in the list should be separated by a semicolon.
Look for spaces between the semicolon and the next application path. Remove any spaces.
If you have more than one Oracle installation, make sure the latest version appears in the PATH before any older versions. If you have uninstalled older versions and references still exist in the PATH then remove them.
If the PATH appears fine then the issue may be rights related.
I have installed Oracle Database Server 12 C 64 bit and Oracle Database Client 12C 64 bit.
I can connect Database with OCBC Driver . But when I opened web site from IIS . Error is showing like that picture and as below.
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’ [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed /include/connection.asp, line 64
I have already tried as you advised .But it doesn’t works. Please advise .
I tried to install with 32 bit. After 32 bit installation , even though I can connect with odbc, I cannot connect with sql plus. So I connect with 64 bit odbc, it works for odbc. But below error is still showing.
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed