I am trying to connect from an ASP page to mysql DB.

I need the connection string and a basic example.

questions:

How diffrent is MySQL from SQL server ?
Does it return the same recordset object ?
How do I declare the variables ?
will a server.createobject ("ADODB.recordset") would work with it or do I need something else ?
which is better mySQL or Access ?

Thank you very much