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
|