Provider cannot be found. It may not be properly installed.
280930Jul 15 2004 — edited Jul 29 2004I 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?