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

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

Hi

I forgot do this... but it didnt help

Ondrej

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