|
|
||||||
|
||||||
| Index Link To US Private Messages Archive FAQ RSS | ||||||
| Web Programming Discussion Forum Working with an API? Developing a plugin? Writing a Mod or script for your favorite blog, Web 2.0 site or Forum? Welcome. |
Share Thread: & Tags
|
||||
|
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|||
|
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 |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
WebProWorld |
Advertise |
Contact Us |
About |
Forum Rules |
MVP's |
Archive |
Newsletter Archive |
Top |
WebProNews
WebProWorld is an iEntry, Inc. ® site - © 2009 All Rights Reserved Privacy Policy and Legal iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509 |