SQL*net ODBC - Urgent Please Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQL*net ODBC - Urgent Please Help

  1. #1
    Join Date
    Aug 2002
    Posts
    18

    Question

    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!

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

  3. #3
    Join Date
    Aug 2002
    Posts
    18
    Thank you Shestakov.
    I will check it out.

  4. #4
    Join Date
    Aug 2002
    Posts
    18
    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.
    I could not find the :Microsoft ODBC Administration
    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!

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

  6. #6
    Join Date
    Aug 2002
    Posts
    18
    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width