Skip to main content
 
developerWorks
AIX and UNIX
Information Mgmt
Lotus
New to Lotus
Products
How to buy
Downloads
Live demos
Technical library
Training
Support
Forums & community
Events
Rational
Tivoli
WebSphere
Java™ technology
Linux
Open source
SOA and Web services
Web development
XML
My developerWorks
About dW
Submit content
Feedback



developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 4 and 5 Forum

Notes/Domino 4 and 5 Forum

developerWorks

  


Please read if you are using NotesSQL and IIS
Ronald Wilkins 18.Jul.01 04:15 PM Lotus Notes
Lotus Tools -- NotesSQL All Releases Windows NT

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


        Please read if you are using NotesS... (Ronald Wilkins 18.Jul.01)
        . . RE: Please read if you are using No... (david l parker 25.Jul.01)
        . . . . RE: Please read if you are using No... (Ronald Wilkins 25.Jul.01)
        . . . . . . RE: NOTES SQL 3.01 wit IIS stinks!!... (Ricky M 2.Aug.01)
        . . . . . . . . get a grip> RE: NOTES SQL 3.01 wit ... (Ronald Wilkins 2.Aug.01)
        . . . . . . . . . . RE: No offense meant, Ron. (Ricky M 3.Aug.01)
        . . . . . . . . . . . . RE: No offense taken! (Ronald Wilkins 3.Aug.01)
        . . . . . . . . . . . . . . RE: No offense taken! (Kevin Colecloug... 5.Nov.01)
        . . . . . . . . . . . . . . . . same problem here - this is what we... (Darren Davison 7.Nov.01)
        . . . . . . . . . . . . . . . . . . more info.. (NotesSQL and IIS) (Darren Davison 8.Nov.01)
        . . . . . . . . . . . . . . . . . . . . oh dear.. (NotesSQL and IIS) (Darren Davison 9.Nov.01)
        . . . . . . . . . . . . . . . . . . . . . . NotesSQL and IIS - the solution?! (Mathias Berg 9.Nov.01)
        . . . . . . . . . . . . . . . . . . . . . . . . RE: NotesSQL and IIS - the solution... (Darren Davison 13.Nov.01)
        . . RE: Please read if you are using No... (Ronald Wilkins 2.Apr.02)
        . . . . Response to: Please read if you are... (Stefan Stokmo 25.Jun.02)
        . . . . . . RE: Response to: Please read if you... (Terence L Dundi... 4.Sep.03)
        . . . . RE: Please read if you are using No... (Patricia M Rank... 23.Sep.04)
        . . NEW FIX/SOLUTION! :) .......? (mete h kamil 14.Jul.06)






          Document options
        Print this pagePrint this page

         Search this forum

          Forum views and search
        Date (threaded)
        Date (flat)
        With excerpt
        Author
        Category
        Platform
        Release
        Advanced search


         RSS feedsRSS
        All forum posts RSS
        All main topics RSS
        More Lotus RSS feeds

         Resources
        Forum use and etiquette
        Native Notes Access
        Web site Feedback

          Lotus Support
        Lotus Support
        Product support pages index
        Search knowledge base (Technotes)
        Search support downloads
        Lotus Support RSS

         Wikis
        IBM Composite Applications
        IBM Mashup Center
        IBM Connections
        IBM Docs
        IBM Forms
        IBM Mobile Connect
        IBM Sametime
        IBM SmartCloud for Social Business
        IBM Web Experience Factory
        Lotus Domino
        Lotus Domino Designer
        Lotus Expeditor
        Lotus Foundations
        Lotus iNotes
        Lotus Instructor Community Courseware
        Lotus Notes
        Lotus Notes & Domino Application Development
        Lotus Notes Traveler
        Lotus Protector
        Lotus Quickr
        Lotus Symphony
        IBM Web Content Manager
        WebSphere Portal

         Lotus Forums
        Notes/Domino 9.0
        Notes/Domino 8.5 + Traveler
        Notes/Domino XPages development forum
        Notes/Domino 8
        Notes/Domino 6 and 7
        Notes/Domino 4 and 5
        IBM Connections
        IBM Forms
        IBM Mobile Connect
        IBM Sametime
        IBM SmartCloud Notes
        IBM SmartCloud Meetings
        IBM Web Content Manager
        Lotus Domino Document Manager
        Lotus e-learning
        Lotus Enterprise Integration
        Lotus Expeditor
        Lotus Protector
        Lotus Quickr
        Lotus SmartSuite
        Lotus Symphony
        Lotus Symphony Developer Toolkit Support
        Lotus Workflow