Use ADO. Add a project reference to Microsoft OLE DB ActiveX Data Objects 1.0 Library. Then, use this code:
Code:
Dim conn1 as ADODB.Connection
Dim rst1 as ADODB.Recordset
Dim SQLConnect as String
Dim SQLSelect as String
SQLConnect = <connectionstring> ' I'm not sure what the MySQL Connection string is...just do a search for "MySQL ADO Connection String"
Set conn1 = new ADODB.Connection
conn1.ConnectionString = SQLConnect
conn1.Open
Set rst1 = conn1.Execute(SQLSelect)
That should get you started on your way. Sorry I couldn't be more specific, but I was just going off the top of my head. Hopefully that helped you out a little bit. Good luck!
Enter your message below
Sign in or Join us (it's free).