Forum Moderators: mack
<html>
<body><%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conndo until rs.EOF
for each x in rs.Fields
Response.Write(x.name)
Response.Write(" = ")
Response.Write(x.value & "<br />")
next
Response.Write("<br />")
rs.MoveNext
looprs.close
conn.close
%></body>
</html>
....im wodering why it didnt work on my pc.i have IIS already running but only a white blank page appeared..what seems to be the problem?
Part of the problem in troubleshooting this is that all you're getting is a blank page. There's a setting in IE that may help give you a better idea of where the problem lies. In IE, go to Tools, then Internet Options, then click the Advanced tab. Find "show friendly HTTP error messages" and take the check off. When building ASP pages, this friendly HTTP error messages can often hide the useful info you need to fix a problem. Also, make sure c:/webdata/northwind.mdb is a valid path to your Access database, and make sure you don't have it open for editing. If you are still having problems, try the Microsoft related forum (http://www.webmasterworld.com/forum47/), lots of helpful people there.
