471,075 Members | 1,184 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

ADO DNS-LESS Connetion

I am trying to use VB/ADO to connect MySQL. I download MyOLEDB and
install the on the machine.

But it keep showing "MySQL DataSource Name Setup" dialog. How can get
away with it?

Following are the code:

cnn.ConnectionString =
"Provider=MySQLProv;Server=localhost;DB=mydb;U ser Id=root;password="
cnn.Open

THX

John
Jul 19 '05 #1
2 3316
I found out how: the connect string should say "Data Source='server=....'"

qj****@wowway.com (Q. John Chen) wrote in message news:<89**************************@posting.google. com>...
I am trying to use VB/ADO to connect MySQL. I download MyOLEDB and
install the on the machine.

But it keep showing "MySQL DataSource Name Setup" dialog. How can get
away with it?

Following are the code:

cnn.ConnectionString =
"Provider=MySQLProv;Server=localhost;DB=mydb;U ser Id=root;password="
cnn.Open

THX

John

Jul 19 '05 #2
I found out how: the connect string should say "Data Source='server=....'"

qj****@wowway.com (Q. John Chen) wrote in message news:<89**************************@posting.google. com>...
I am trying to use VB/ADO to connect MySQL. I download MyOLEDB and
install the on the machine.

But it keep showing "MySQL DataSource Name Setup" dialog. How can get
away with it?

Following are the code:

cnn.ConnectionString =
"Provider=MySQLProv;Server=localhost;DB=mydb;U ser Id=root;password="
cnn.Open

THX

John

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by GriffithsJ | last post: by
9 posts views Thread by Leigh | last post: by
7 posts views Thread by Roger Bavaud | last post: by
2 posts views Thread by David Arden Stevensonn | last post: by
4 posts views Thread by MSNews | last post: by
7 posts views Thread by kvnsdr | last post: by
9 posts views Thread by Michael | last post: by
5 posts views Thread by =?Utf-8?B?UVNJRGV2ZWxvcGVy?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.