Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2015
  • 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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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