stefanRusterholz
Programmer
I'm still a newbie, so please explain stepwise ;-)
I got following problem: i need to access (on the local machine) a mysql database. I downloaded myODBC 2.50.38 from mysql.com ( but i couldn't get it run.
The old code which accesses an MS Access DB instead of the mySQL DB is the following:
As I understand VB, I just needed to change the connectionstring. But to what?
Thanks for helping!
Stefan
I got following problem: i need to access (on the local machine) a mysql database. I downloaded myODBC 2.50.38 from mysql.com ( but i couldn't get it run.
The old code which accesses an MS Access DB instead of the mySQL DB is the following:
Code:
Dim rs As ADODB.recordset
Dim connStr As String
Dim SQLquery As String
Set rs = New ADODB.recordset
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\database.mdb"
SQLquery = "SELECT something FROM mytable"
rs.open SQLquery, connStr
As I understand VB, I just needed to change the connectionstring. But to what?
Thanks for helping!
Stefan