Microsoft Internet Information Server
You may receive the following error messages if any general error happens during a connection using an application that utilizes the OLE DB Provider for ODBC. The OLE DB Provider is returning this error, not NotesSQL.
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Check the following
- Your IIS Internet Guest Account may not have sufficient rights to the Windows Temp directory, NotesSQL needs to write temporary files to that directory.
The Temp directory location is different between WinNT 4 and WinNT 2000 in that in WinNT 4, the Temp directory was typically off of the SystemRoot drive and all users/processes used the same Temp directory. That is different in WinNT 2000, the Temp directory in 2000 is in the SystemRoot drive:\Documents and Settings\{User's Logon Name}\Local Settings\Temp. Also in Win2000, System Processes and Services have their own Temp directory, by default this is \WinNT\Temp. This directory is the directory WinNT gives NotesSQL to process temporary files. Unfortunately, by default, IIS does not assign enough rights to it's Internet Guest Account (typically either IUSER or IUSR or IUSR_{Server Name}).
To resolve this problem, you need to assign Full rights for the Internet Guest Account (IUSR_{Server Name}) to the Temp directory (\WinNT\Temp).
- Your IIS Internet Guest Account may not have sufficient rights to the Notes/Domino and NotesSQL directory. To resolve this problem, you need to assign Read and Write rights for the Internet Guest Account (IUSR_{Server Name}) to the Notes/Domino directory, NotesSQL directory and the directory that contains the ID file of the user for authentication (if in a different directory than the Notes\Data directory).
- You may have not set a UserName/Password in the DSN or passed the UID/PWD in your Connection string. Since IIS is a background operation, you need to provide the authentication in one of these places in order to make a connection.
- The UserName or the Password you passed in your DSN or Connection string is not correct. Please read the section in the NotesSQL documentation on setting up a user to be used for authentication.
- If you are using a DSN to access your database, make sure that it is a System DSN and not a User DSN as IIS runs as a service and will not access user specific registry entries. You may also need to check the rights of that registry entry and verify your Internet Guest Account (typically either IUSER or IUSR or IUSR_{Server Name}) has sufficient rights to read that entry. To do this, use regedt32 to navigate to HKEY_LOCAL_MACHINE\Software\ODBC and select the Security/Permissions... menu, verify that the Internet Guest Account is listed explicitly or belongs to a group in the list and that entry has at least Read rights to the registry entry.
- You may have to update Microsoft's Jet Engine, install Microsoft Jet 4.0 Service Pack 5 (SP5) from the Microsoft website:
You should also check the following Microsoft Tech Support articles, they may refer to specific products with IIS, but the information is also pertinent to NotesSQL:
Q183060 - INFO: Troubleshooting Guide for 80004005 and Other Error Messages Q189408 - PRB: ASP Fails to Access Network Files Under IIS 4.0 Q295297 - PRB: Error Message: 0x80004005: General Error Unable to Open Registry Key
Return to top
Please read if you are using NotesS... (Ronald Wilkins 18.Jul.01) 
. . 
Print this page
