DevOps, CI/CD and Automation

Hi,

we updated our Oracle server to 10.2.0.4 and since then I receive the error: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed on my local machine (which has an ODBC connection which I used by Classic ASP webpages running on IIS).

I can create a new ODBC connection and test it (with the Test Connection option), which works. However, when I try to access the ASP page IIS throws the error.

I have several Oracle products installed and i've set the TNS_ADMIN environment variable to point to a single Oracle home. Installed products are:
- Oracle Client 10g release 1
- Oracle InstantClient Release 2 with ODBC library
- Oracle ODAC 11g for .NET
- Oracle Gateway 11g

Also I have added ASPNET and IUSR_WORKSTATION users to the special policy which allows the creation of global objects on the local machine.

Any suggestions would be more then welcome!