• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2023
  • Last Modified:

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
0
dainiao
Asked:
dainiao
  • 2
4 Solutions
 
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now