Running WIN98-SE-Updates.
Got PWS up and MTS installed.
I have an ASP page to test. When I try to open it from IE, it auto-opens Interdev. When I select to "View in browser", the download window (I think) flashes and the nothing.
"Critters" is my DSN for and Access database (critters.mdb)
Here's the code. It's a sample ASP from the MS book "Web Database Development"
NOTE:I left out the <'s on the html tags so I could list it here.
html>
head>
/head>
body>
p>
%
openstr = "Critters"
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open openstr
sql = "SELECT jersey, fname, sname, position " & _
"FROM roster " & _
"ORDER BY jersey; "
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, cn, 3, 3
On Error Resume Next
rs.MoveFirst
Do While Not rs.EOF
Response.Write Server.HTMLEncode(_
rs.Fields("jersey") & ", " & _
rs.Fields("fname") & " " & _
rs.Fields("sname") & ", " & _
rs.Fields("position")) & "
" & vbCrLf
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
%>
/p>
/body>
The folder that the mdb file and asp page has execute and script permissions enabled.
1)Does it have to go thru InterDev every time?
2)It is supposed to give me an HTML output, but I get nothing. Any suggestions as to what I am doing wrong?
Thanks,
Larry