Unanswered: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Hi, my first post, hopefully somebody can solve my problem.
I have an asp application that runs on IIS with a DB2 database.
The application is setup to use Authenticated Access (through Active Directory). Everything works fine except for one particular case.
The application restarts itself after about 30 minutes of inactivity. If the first person to access the application is authenticated in AD, everything works well, even when those who are not authenticated try to access the application. The problem occurs when someone without authentication initializes the application for the first time. It crashes the connection and then nobody can access the application until there is 30 minutes of inactivity and application restarts.
This is the error I get:
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
I tried giving the IUSR read/write access to the DB2 driver directory, that didn't work.