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