I want to connect with MYSQL database from VB6. Help me, how I can do that.
I have worked with Access and VB but not with server type database before.
Rajib
Printable View
I want to connect with MYSQL database from VB6. Help me, how I can do that.
I have worked with Access and VB but not with server type database before.
Rajib
If you've used ADO with Access then there isn't that big difference between the code you use to connect to MySQL. The main difference is the ConnectionString. Here's a generic ConnectionString that you can use with MySQL:
"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=ThePassword"
you can use dataenvironment as a connection
connect some dsn connection visit www.vbrad.com :thumb:
phrajib,
Look here for an example. Look under Multi Database Control
I'm trying to setting up a connection with a Data Environment to a MySQL DB using MyOLEDB Provider 3.0.
In the Data Link Properties Dialog, I filled all the blank like this :
Data Source : Data
Location : localhost
User name : root
Password : ***
The user and password are correct.
When I click on Test Connection, it always took me to the "MySQL Data Source Name Setup" dialog and there, I don't know what to do.