Hello
I tired to create an asp page (grupa_aaa.asp) for show me information from a table materials (materiale.mdb). Not work. Give me error: "The page cannot be display" What is wrong in code below?
<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
'conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.open"Driver={Microsoft Access Driver(*.mdb)};DBQ=" & Server.MapPath("/materiale.mdb")
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Materials",conn
if rs.EOF then
response.write "No Records!"
else
%>
<table border="1" width="100%">
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
end if
rs.close
conn.close
%>
</table>
</body>
</html>
I tired to create an asp page (grupa_aaa.asp) for show me information from a table materials (materiale.mdb). Not work. Give me error: "The page cannot be display" What is wrong in code below?
<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
'conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.open"Driver={Microsoft Access Driver(*.mdb)};DBQ=" & Server.MapPath("/materiale.mdb")
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Materials",conn
if rs.EOF then
response.write "No Records!"
else
%>
<table border="1" width="100%">
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
end if
rs.close
conn.close
%>
</table>
</body>
</html>