Windows 7 64 Bit, Oracle ... Error3706 Provider Cannot be found . Help Please

Setting Up a new client for a customer

  • Windows 7 Professional 64 Bit
    -VB6
  • Oracle

Error:
Error:3706 Provider Not Found. It may be installed correctly

at first the problem was the MSHFlexGrid.OCX file was missing. I registered the OCX file and it succeeded. Via regsvr32 < OCX File>

Heres the code :

Option Compare Text
Public DevConn As ADODB.Connection

' =================================================================================
' connect to the DeVEX database
' =================================================================================
Private Sub ConnectDB()

On Error GoTo ConnError
' clear the connection string on the form
lblConnection.Caption = ""
Dim strConn As String ' the DeVEX connection string
' set the connection string
strConn = "Provider=OraOLEDB.Oracle.1;Password=jaxbatch123;Persist Security Info=True;User ID=jaxbatch;Data Source=OraDevex"
' create a new connection
Set DevConn = New ADODB.Connection
' set the ConnectionString property to the string above
DevConn.ConnectionString = strConn
' and open the connection
DevConn.Open
If Err.Number > 0 Then
lblConnection.Caption = "DeVEX Connection Error"
lblConnection.BackColor = &H80&
Else
lblConnection.Caption = "DeVEX Connection OK"
lblConnection.BackColor = &H8000&
End If
Exit Sub
ConnError:
MsgBox ("Error:" & Err.Number & "-" & Err.Description)
lblConnection.Caption = "Connection Error"
lblConnection.Caption = "DeVEX Connection Error"
lblConnection.BackColor = &H80&
End Sub

0 answers