OLEDB Provider Error - Supplied Provider is different from the one already in use 
Author Message
 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!!!!!!!



Tue, 29 Jun 2004 01:14:14 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Oracle - Supplied Provider is different from the one already in use

2. Oracle - Supplied Provider is different from the one already in use

3. Supplied Provider Different

4. Supplied provider is different from the one already in use.

5. Determine cause of Error from OLEDB Provider for SQL 7.0

6. MS Access OLEDB provider

7. No OLEDB 9.0 provider in Project 2002 ?

8. Help using OLEDB provider with Project file

9. using Project 200x OLEDB provider from SQL

10. Microsoft.Jet.OLEDB.3.51 provider not registered

11. OLEDB Provider for ODBC drivers with VB.NET

12. Building a OLEDB Provider usding VB.NET

 

 
Powered by phpBB® Forum Software