Solved

OLE DB Driver for mysql

Posted on 2004-03-26
4
1,971 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Install MySQL 5.6 and PHP on Centos Linux 6 119
What does "flush tables;" do exactly? 7 98
MSSQL 2008 with mySQL webservers 7 51
MySQL Memory Keeps Increasing 4 34
A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 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

18 Experts available now in Live!

Get 1:1 Help Now