Connecting using ASP

[mmltonge]

Hi, i recently transferred hosts without checking whether i could continue using access. The new host only uses MySQL databases, they have set up a DSN connection for me under the name 'Festival' My current code reads

<%
Dim objRec
strConnect = "Driver={Microsoft Access Driver (*.MDB)}; DBQ="& Server.Mappath("websitedb0283716391.mdb")
set objRec = Server.CreateObject("ADODB.Recordset")
objRec.Open "SELECT * FROM LINEUP ORDER BY DAY", strConnect

^^^^ Firstly what would i need to change to to get it to work with MySQL if the DSN name is Festival, user name is Festival and password is readfest2004?

Response.Write
... ---- Creating the table headers
Do While Not objRec.EOF
Response.Write "<tr><td align='center'><font color='#000000' size='2' face='Verdana, Arial, Helvetica, sans-serif'>" & objRec("BANDNAME") & "</font></td><td align='center'><font color='#000000' size='2' face='Verdana, Arial, Helvetica, sans-serif'>" & objRec("STAGE") & "</font></td><td align='center'><font color='#000000' size='2' face='Verdana, Arial, Helvetica, sans-serif'>" & objRec("DAY") & "</font></td></tr>"

^^^^^^^ Will i need to change the code used to display items?

objRec.MoveNext
Loop
Response.Write "</table>"
objRec.Close
Set objRec = Nothing

^^^^^^^ any of that need changing?
%>

As far as i can tell all that needs to be really sorted out it the top section PLEASE help

Thanks
Mark

[mmltonge]

ok i sorted it i had the DSN name incorrect :)