mysql and ASP

[Passero]

Hi all, i've just set up an mysql server on my computer and now i want to
connect to a mysql database with an ASP page but i can't find the correct
connection string. I always get an error that the datasource can not be
found.

ConnString =
"Driver={MySQL} ;SERVER=mysqlho st;DATABASE=myD B;UID=userID;PA SSWORD=pasword"

What's wrong with it?

[Erland Sommarskog]

Re: mysql and ASP

[posted and mailed]

Passero (yanongena@pand ora.be) writes:
[color=blue]
> Hi all, i've just set up an mysql server on my computer and now i want to
> connect to a mysql database with an ASP page but i can't find the correct
> connection string. I always get an error that the datasource can not be
> found.
>
> ConnString =
>
>"Driver={MySQL };SERVER=mysqlh ost;DATABASE=my DB;UID=userID;P ASSWORD=pasword "
>
> What's wrong with it?[/color]

No idea, but you are probably more successful in getting an answer if
you ask in a forum devoted to MySQL. You posted your question in groups
related to MS SQL Server.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp