OLE DB Driver for mysql

Does anyone know where to get ole db driver for mysql? MyOLEDB 3.0 I download from mysql.com does not work well. I am working with windowXP and mysql version is 4.0.17
dainiaoAsked:
Who is Participating?
 
SqueebeeCommented:
There is no OLE DB driver in active development. I would recommend MyODBC.
0
 
SlothManCommented:
I had the same problem as you, I changed to MyODBC instead.  The DSN-less connection string I use from VB6 is as follows:

strConnectionString = "Provider=MSDASQL.1;DRIVER={MySQL ODBC 3.51 Driver};Persist Security Info=True;DATABASE=mydatabase;SERVER=192.168.1.1;UID=aaron;PWD=fj4sdgf;"
0
 
AndyCommented:
Here is the link to the latest prodution version of said MySQL ODBC Driver...

http://www.mysql.com/downloads/api-myodbc-3.51.html
0
 
SqueebeeCommented:
Slothman:

You may want to look at the connection string at:

http://www.vbmysql.com/samplecode/simpleinsert.html

It should be better for VB6.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.