Solved

OLE DB Driver for mysql

Posted on 2004-03-26
4
1,969 Views
Last Modified: 2010-05-18
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
Comment
Question by:dainiao
  • 2
4 Comments
 
LVL 17

Accepted Solution

by:
Squeebee earned 75 total points
ID: 10693599
There is no OLE DB driver in active development. I would recommend MyODBC.
0
 

Assisted Solution

by:SlothMan
SlothMan earned 25 total points
ID: 10693990
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
 
LVL 6

Assisted Solution

by:Reapz
Reapz earned 25 total points
ID: 10694771
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
 
LVL 17

Assisted Solution

by:Squeebee
Squeebee earned 75 total points
ID: 10695373
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now