Connect Oracle 3706 Provider cannot be found?

I have read countless postings on connecting to Oracle and I am still stumped. One problem may be that I am running a 64 bit machine with 32 bit Oracle installed trying to make everything work. When I look in the BIN folder, i see a bunch of DLL's for Oracle 11. I don't see OraOLEDB.dll though. Just OraOLEDB11us.dll. I try to register that one and my system does not like it. 32 bit?

My Connection String looks like this:

Set oCon = New ADODB.Connection
sPW = InputBox("Please enter the password.", "Password Req'd")

Set Connection = CreateObject("ADODB.Connection")

With oCon
.Provider = "OraOLEDB.Oracle"
.Properties("Data Source") = "SchemaName" 'From TNSNames file
.Properties("User ID") = "username"
.Properties("Password") = sPW '"password"
.Open
End With

The checked items in my Excel references are:
VB for Apps
Microsoft Excel 14.0 Object Lib
OLE Automation
MS Office 14.0 Object Lib
MS ActiveX Data objects 2.8 Lib
MS ADO Ext 2.8 for DDL and Security
MS Data Access Components Installed Version
MS OLE DB Service Component 1.0 Type Lib
MS OLE DB Simple Provider 1.5 Lib

and the error I get is still:
Runtime Error 3706. Provider cannot be found, when it hits .Properties("Data Source") = "SchemaName".

Any suggestions?? This same code works on other machines, but I don't know why.

3 answers