Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Provider cannot be found. It may not be properly installed.

280930Jul 15 2004 — edited Jul 29 2004
I have a Visual Basic application that can connect to Oracle Database(8.1.7) in another computer.
Oracle 8.1.7 Client is installed in my computer.
So, When I attempt to run the VB app from my PC, I get the following error:

Run-time error '3706' or '-2147467259'
Provider cannot be found. It may not be properly installed.

But, I can run SQLPLUS and run commands. That part is fine.

Here is the Visual Basic connect string from the code:
1)
Dim Cs As String
Set OraCon = New ADODB.Connection
Cs = "Provider=OraOLEDB.Oracle;Password= " & Password & "; User ID= " & UserID & ";Data Source= " & DataSource & "; Persist Security Info=true "
OraCon.CommandTimeout = 30
OraCon.ConnectionString = Cs
OraCon.Open Cs
2)
Set OraCon = New ADODB.Connection
With OraCon
.CursorLocation = adUseClient
.Provider = "MSDAORA.1"
.Open DataSource, UserID, Password
End With

How can i sovle this problem?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2004
Added on Jul 15 2004
4 comments
17,192 views