cboshdave
12-13-2013, 07:02 AM
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.
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"
.Properties("User ID") = "username"
.Properties("Password") = sPW '"password"
.Open
End With
My References window looks like this:
10960
Well, that's not gonna work. The checked items 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.
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"
.Properties("User ID") = "username"
.Properties("Password") = sPW '"password"
.Open
End With
My References window looks like this:
10960
Well, that's not gonna work. The checked items 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.