Printable View
I try to connect to oracle database by ASP application.
I got the follow error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).
The server has oracle 9i installed,
I am able to connect to the database through SQLplus on the server.
I am sure the ASP code is correct, because I use the same
code for other servers.
Please help, thanks!
U have to use: Microsoft ODBC Administrator
Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Microsoft ODBC Administration
Read "Microsoft ODBC Administration online help" how u can setup new odbc driver for oracle.
Thank you Shestakov.
I will check it out.
I could not find the :Microsoft ODBC AdministrationQuote:
Originally posted by Shestakov
U have to use: Microsoft ODBC Administrator
Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Microsoft ODBC Administration
Read "Microsoft ODBC Administration online help" how u can setup new odbc driver for oracle.
under :Configuration and Migration Tools.
I think oracle is not completely installed on the server.
Should I de-install and resinstall the oracle?
My company want to use oracle OLEDB for the connection (not ODBC), would that solve the connection problem without resinstall the oracle?
Thanks!
Yes it possible.
If u didn't install oledb before u can add it in any time using oracle installer.
-----------------------------------------------------------------
About ODBC Administrator.
In any way u can found it in MS WIN control panel.
My DBA install the oracle OLEDB driver to the server, but I got the error.
And we try to de-install and reinstall the oracle, and use OLEDB. I still got error: (Which I coded ASP use OLEDB)
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
This is very frustrate.
The Web server is win2000 and has Oracle 9i installed. Does win2000 need some more configuration?
[Edited by Amy00 on 10-04-2002 at 08:20 AM]