This content has been marked as final. Show 16 replies
Were there any errors when you installed the client or the latest ODBC driver? If the installer wasn't able to create the appropriate registry entries, I wouldn't do so myself, simply because that may confuse the installer when you get it fixed-- those registry entries should have been created already.
Are you installing the Oracle client as a user with Administrator privs? If not, can you try that-- perhaps you don't have the privs needed to write to the registry.
Unfortuately, system errors are Microsofts and I'm not seeing anything in the Knowledge Base indicating the cause of that error, so it's hard to guess what's wrong.
Sorry to wake this one up, but I have just encountered this problem.
I have de/re installed the ODBC driver and rebooted. I am logged on as Administrator too.
Are you seeing the driver in the list of available drivers in the Data Source Administrator?
What version of Windows, Oracle, and the Oracle ODBC driver are you using?
Distributed Database Consulting, Inc.
Actually, I tried to run SQL Plus and it failed with ORACLE_HOME issues. I am unsure what happened when the guy installed version 8 and 9.2 but I fear a sequence was incorrect somewhere. Therefore, please disregard this post.
However, I would suggest that if anyone else gets this particular error they run SQL Plus to validate the install.
I happened to notice a Metalink note this morning that indicated that this may be a permissions issue. If the user that is attempting to invoke ODBC (or OLE DB, OO4O, etc) doesn't have permission on the %ORACLE_HOME% directory and subdirectories, this error may be thrown. If an Administrator account installs the software, make sure that the appropriate file system permissions are granted.
Distributed Database Consulting, Inc.
I just have this error, and realised the mistake was due to the path variable to the ODBC driver was not set.
Hope it's applicable to you too..
After the installation the environment needs to be configured in the following way.
Add the directory to the PATH system environment variable.
Otherwise ODBC manager will be not able to load/find the driver.
Thank you very much Fred.
It was exactly this fix.
I'm trying to use Oracle 10 Express on Microsoft Vista but get the following error "ODBC driver could not be loaded due to system error code 998". Could someone please let me know the exact solution to get around this error?
I had the same problem on my WindowXP machine. I upgrade to the lastest ODBC drive. The problem didn't go away. In reading more of the artical, I notice the reference to path being an issue. I have several Oracle products installed on this machine so I looked to see where the ODBC path was in the path setting. It was last. I moved it to the front and the problem was solved.
Hope this help...
I had the same issue and I checked the environment variable for the PATH. It turns out the the path was all lower case "c:\orant\bin\" and the actual install directory was "C:\Orant\BIN". I modified the PATH variable to reflect the "C:\Orant\BIN" and that fixed my problem
I had the same problem but none of the solutions proposed in this thread could fix it.
My mistake was to install the ODBC driver in a directory different from the Oracle Client directory! This is incorrect but the Universall Installer told me the ODBC driver installation was successfull...
So, make sure you precise the right Oracle Home directory during the ODBC driver installation.
Hope it helps!
Just resolved this problem myself and will echo what another poster suggested - the case in my PATH variable was not consistent with the actual directory. After fixing it, the problem was resolved.
<insert snide Oracle comment here>
I had the same issue, except in my case the PATH entry was fine, it was the driver entry in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ where I had to change the case.
I'm suffering with the same problem. I installed OTN and I can see Ora entry in ODBC driver. But I can't connect from ODBC or Visual Studio getting always the same error message as listed in this forum. But I did just running the instalation of Ora and it's not working. Terrible software...