Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    41

    Unanswered: Problem with Oracle provider

    Hello,

    I have problem with creating connection to Oracle db. I use OraOLEDB provider and when I want connection open I get this error message:"Provider cannot be found. It may not be properly installed."

    This is my connection string:
    oConn = Server.CreateObject("ADODB.Connection");
    sConn = "Provider=OraOLEDB.Oracle.1;";
    sConn += "Password="+password+";"
    sConn += "User ID="+username+";"
    sConn += "Data Source="+db.dbname+";Log Level=0";

    oConn.Open(sConn)

    I've installed driver manualy reinstalled MDAC but it still doesnt work.

    Can anybody help me please!!

    Thanks, Ondrej

  2. #2
    Join Date
    Aug 2003
    Location
    UK(berkshire)
    Posts
    11

    Re: Problem with Oracle provider

    Hi

    Try the following

    goto your oracle directory... and add full permissions to it for the iwam_user and the other iuser...

    whichever is in iis as the user...

    cheers

    youeee

    Originally posted by ohanus
    Hello,

    I have problem with creating connection to Oracle db. I use OraOLEDB provider and when I want connection open I get this error message:"Provider cannot be found. It may not be properly installed."

    This is my connection string:
    oConn = Server.CreateObject("ADODB.Connection");
    sConn = "Provider=OraOLEDB.Oracle.1;";
    sConn += "Password="+password+";"
    sConn += "User ID="+username+";"
    sConn += "Data Source="+db.dbname+";Log Level=0";

    oConn.Open(sConn)

    I've installed driver manualy reinstalled MDAC but it still doesnt work.

    Can anybody help me please!!

    Thanks, Ondrej
    Thanks

    youeee

  3. #3
    Join Date
    Jan 2003
    Posts
    41

    Re: Problem with Oracle provider

    Hi

    I forgot do this... but it didnt help

    Ondrej


    Originally posted by youeee
    Hi

    Try the following

    goto your oracle directory... and add full permissions to it for the iwam_user and the other iuser...

    whichever is in iis as the user...

    cheers

    youeee

  4. #4
    Join Date
    Jan 2003
    Posts
    41

    Thumbs up Re: Problem with Oracle provider

    I'm so sorry... it works

    The problem was I didnt set FULL PERMISSIONS for the user...

    Thank you very much for your help!!!!

    Bye
    Ondrej

    Originally posted by youeee
    Hi

    Try the following

    goto your oracle directory... and add full permissions to it for the iwam_user and the other iuser...

    whichever is in iis as the user...

    cheers

    youeee

Posting Permissions

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