Thanks a lot WebspoonUK ..That did really help me solve the problem. Thanks a million :)
when I try running this asp using iexplorer, it does not return anything other than 'Country..... City..... Currency..... Population' as heading. How come it's not connecting and getting the data from the database?? Please help! Thanks
<% @language = VBScript %> <head> <TITLE>ASP - Country Query</TITLE> <body> <% Dim MyConn, MydbFilePath Set MyConn = Server.CreateObject("ADODB.Connection") MydbFilePath = Server.MapPath("countrydb.mdb") MyConn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & MydbFilePath & ";" query1 = "SELECT * FROM Countrytbl" Set RS = MyConn.Execute(query1) %> Country..... City..... Currency..... Population<br><br> <ul> <% WHILE NOT RS.EOF %> <li> <% =RS("Country") %> ..... <% =RS("City") %> ..... <% =RS("Currency") %> ..... <% =RS("Population") %> </li> <% RS.MoveNext WEND %> </ul> </body> </head>
