Connecting using ASP
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
|