5 Replies Latest reply on Apr 4, 2007 8:31 PM by sbracken

    Driver Could not be loaded

    417980
    417980 Mar 29, 2004 3:06 PM
      Hi,
      I am getting this error, when i am trying to make a database connection using oracle.
      Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
      Specified driver could not be loaded due to system error 998 (Oracle in OraHome92).

      I have tested my DSN, it connects successfully. I have checked my data source using tnsping,sqlplus, works fine.
      I have also given IUSR,IWAM permissions to ora92 directory/sub-directories.

      The code i am using is:
      Dim DConn
      Set DConn = Server.CreateObject("ADODB.Connection")
      DConn.Open "DSN=xyz;uid=abc;pwd=abc"
      DConn.Close
      Set DConn = nothing

      thanks.
      • 15677 Views
      • Tags:
        • 1. Re: Driver Could not be loaded
          82532
          82532 Mar 29, 2004 4:16 PM (in response to 417980)
          System error 998 = Invalid access to memory location.
          Probably not a permissions error. Make sure there are no duplicates of the oracle DLLs (like OCI.DLL) floating around. There should just be the ones in the $Oracle_home/bin directories. Then make sure the environemt PATH is set to include the one you want to load (OraHome92) first in the path statement for the user the process runs as (IUSR,IWAM I am guessing).
          • 2. Re: Driver Could not be loaded
            417980
            417980 Apr 1, 2004 10:18 PM (in response to 82532)
            I checked both things and
            1. there are no duplicates dlls as you mentioned
            2. the PATH is already set correctly in enviornment variables to..c:\oracle\ora92\bin
            How do i check that it is set for (IUSR,IWAM users)?
            What else could be the reason for the error?
            • 3. Re: Driver Could not be loaded
              420002
              420002 Apr 26, 2004 11:03 PM (in response to 417980)
              This is what happened to me. I was getting the error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
              Specified driver could not be loaded due to system error 5. I then gave IUSR_machine name account and the IWAM_machine name accounts full access to the Bin folder.

              I then got the error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Specified driver could not be loaded due to system error 998. I then gave IUSR_machine name account and the IWAM_machine name accounts full access to the whole Oracle home folder C:\Oracle\OraHome92, and it is working!!!!!

              Hope this helps.

              Thx,
              Scott Buerkley
              • 4. Re: Driver Could not be loaded
                567301
                567301 Mar 15, 2007 10:47 PM (in response to 420002)
                I got the similar issue, but when I tried to grant access for the IUSR_machine name user account for the ora92/bin directory, I got the following message:

                "An object named "IUSR_machine name" cannot be found. Check the selected object types and location for accuracy and ensure that you typed the object name correctly, or remove this object from the selection."

                So it sounds like my PC cannot recognize the machine name?

                Thanks,
                • 5. Re: Driver Could not be loaded
                  sbracken
                  sbracken Apr 4, 2007 8:31 PM (in response to 567301)
                  Be careful! There will be no account called "IUSR_machine name". If your machine's name is "Fred" then the account will be called "IUSR_Fred". You might need the domain in front of that e.g "YOURDOMAIN\IUSR_Fred".

                  Hope that helps