connection string from windows, please help

[Trym Bagger]

Hello all:

I have just installed mysql via the new windows installer program on my Windows XP Pro machine, and everything works perfectly. Now I would like to make a connection from an asp page to the database (locally on my computer)

The connection string which I use on my mysql database on my web site (externally) is

<%
set Conn = server.CreateObject("ADODB.connection")
Conn.open "Provider=MySQLProv;Location=mysql.myweb.com;Data Source=lacanela;User Id=myname;Password=mypw;"
%>

and that works perfectly.

Now I would like to use the same string for local connections on my PC.

I have tried:

<%
set Conn = server.CreateObject("ADODB.connection")
Conn.open "Provider=MySQLProv;Location=localhost;Data Source=localhost;User Id=root;Password=pw;"
%>

But I get the following error message:

ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.

That leads to several questions:

- Are the Location and Data source arguments correct? (I did not specify anything particular when installation windows package, the user root was automatically created.

- Do I have install something extra in order to make MySQLProv work locally on my computer?

Are there any alternatives to MySQLProv (I prefer OLEDB, not OBDC) - already natively available on win XP Pro?

Thanks a lot!

TB