I got this Database that is Online thats hosted through the Website and uses MySQL, and the Tables have some Data I like to Read From. Heres what I got (I used Jim's Data Read Thread)
vb Code:
Public Sub testconnect() Dim sqlconn As String = "Server=63.247.93.106;Database=viina_schoolbook;User=---; Password=---;" Using Connection2 As New SqlConnection(sqlconn) Using commanda As New SqlCommand("SELECT Keys From viina_schoolbook", Connection2) Connection2.Open() Using reader2 As SqlDataReader = commanda.ExecuteReader() While reader2.Read() MsgBox(reader2("keys")) End While End Using End Using End Using End Sub
When I tried doing this as the SQL Connection String:
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;
I got an Error saying Driver is Invalid.




Reply With Quote