This content has been marked as final. Show 5 replies
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).
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?
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.
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?
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