Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Post Unanswered: nned help with oraoledb

    I wrote some asp pages using an oracle database with this connection string:

    Set objConn = Server.CreateObject("ADODB.Connection")

    objConn.Open("Provider = OraOLEDB.Oracle; Data Source =Esemar; User id=scott; password=tiger")


    that was perfect for oracle 8i using a DSN called "Oracle ODBC driver" available in Microsoft ODBC Administrator.

    But now I need to use Oracle 9i instead, and the only dns available is "Oracle in Orahome92": the connection test is always successfull, but when I try to connect my asp page with the same string as above it says an error of "unable to find the provider"


    Anybody can please help me?

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    do you have the oracle oledb capability installed ?
    this is an additional option with the client installation

    In your registry you should be able to find an OraOLEDB.Oracle entry ...

    (hky_classes_root\clsid\ ...

  3. #3
    Join Date
    Dec 2003
    Posts
    3
    yes..I found it in

    HKEY_CLASSES_ROOT\CLSID\{3F63C36E-51A3-11D2-BB7D-00C04FA30080}

  4. #4
    Join Date
    Dec 2003
    Posts
    3
    but now what I've to do?

Posting Permissions

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