ASP and mySQL

How do I make the connection?

[circuitjump]

Hey all,
Just want to know if anyone can help me with ASP and mySQL and how make the connection?

With MS Access I do this ....

variable-name = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("mail.mdb")

Help!

Thanks

[Air]

Apparantly you do this:

<%
ConnectionString="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://127.0.0.1:3306/yourDBName};uid=username;pwd=yourMySQLpassword;"
set con = Server.CreateObject("ADODB.Connection")
con.open(ConnectionString)
%>

Found that HERE [kangaweb.com]
Sorry I can't help further, ASP is not my bag baby, if you ever do PHP & MySQL then I'm there ...

[Xoc]

To create the string that you need to connect to any ADO provider:

1) create a file with the file extension .udl on your hard disk. This can be a zero length text file.

2) Right click on the file in the Windows Explorer and select Properties from the menu.

3) There is a tab that will lead you through a series of dialogs for doing the connection.

4) Close all the dialogs.

5) Open the UDL file in Notepad. The string you want will be in the file.

[circuitjump]

Thanks Air and Xoc. I appreciate the help.
Between the info I got from the both of ya'll I got it to work.

Thanks!