ADO DNS-LESS Connetion

[Q. John Chen]

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

[Q. John Chen]

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

[Q. John Chen]

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