Koristim ODBC 5.1 Driver, konekciju na localhost, ODBC je povezan:
Code:
Public cn As New ADODB.Connection
Public rs As ADODB.Recordset
Public Sub openconn()
Set cn = New ADODB.Connection
cn.Provider = "Driver={MySQL ODBC 5.1 Driver}; Server=localhost; Database=moja_baza; user=root; Password=; Option=3;"
cn.Open '<<<<<<<<<<<<<<<< error
If cn.State = adStateOpen Then
Call MsgBox("radiiiiiiiiiiiiiiiiii", vbExclamation, App.Title)
End If
End Sub
Private Sub Command1_Click()
openconn
End Sub
Public cn As New ADODB.Connection
Public rs As ADODB.Recordset
Public Sub openconn()
Set cn = New ADODB.Connection
cn.Provider = "Driver={MySQL ODBC 5.1 Driver}; Server=localhost; Database=moja_baza; user=root; Password=; Option=3;"
cn.Open '<<<<<<<<<<<<<<<< error
If cn.State = adStateOpen Then
Call MsgBox("radiiiiiiiiiiiiiiiiii", vbExclamation, App.Title)
End If
End Sub
Private Sub Command1_Click()
openconn
End Sub
"error 3076 provider cannot be found. It may not be properly installed"