Last post Sep 22, 2011 06:30 AM by Ken Tucker
Sep 22, 2011 05:36 AM|mickbuckley|LINK
Hi i have a site hosted by dataflame and i'm having trouble connecting to a MySQL database.
I can set up a database on my PC and connect to it no problem but when i try using the same connection string on my hosted site i can't connect.
both the following connection strings work on my pc but not on the hosted server
Id=test;password=1234;Persist Security Info=True;database=test"
The first one gives the error keyword not supported 'Dsn'
and the second one gives the error login failed for user 'test'
what am i doing wrong?
Sep 22, 2011 06:03 AM|Ken Tucker|LINK
Use the mysql dot net connector
Sep 22, 2011 06:19 AM|mickbuckley|LINK
I don't think i'll have any control over putting this on my hosted site, i already have it on my local pc.
unless i'm misunderstanding you
Sep 22, 2011 06:30 AM|Ken Tucker|LINK
You just include the dll with your web site