
OLEDB Provider Error - Supplied Provider is different from the one already in use
I get this message when I am trying to connect via ADO using OleDB:
Error # 3220
Error - Supplied Provider is different from the one already in use
Technologies:
Vb 6 sp5
Windows 2000, IIS 5 & COM+
Oracle OleDB provider 8.1.7.2
I have a VB Com+ object that creates a connection object and recordset
object, I connect and try to execute a Sql statement and I get this error
message. "Supplied Provider is different from the one already in use"
Here is my code and connection string:
Provider=OraOLEDB.Oracle;PLSQLRSet=1;Data Source=DEV;User
Id=scott;Password=tiger;
Code:
Set objConn = New Adodb.connection
Set rsData = New Adodb.recordset
sConn = "Provider=OraOLEDB.Oracle;PLSQLRSet=1;Data Source=DEV;User
Id=scott;Password=tiger;"
objConn.Open sConn
sSql = "Select * from Client"
Set rsData = objConn.Execute(sSql)
Any help, I cannot find this error anywhere on Micrsoft support? HELP!!!!!!!