Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need help getting started
Message
From
28/12/2000 22:34:27
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
All
General information
Forum:
Internet
Category:
Active Server Page
Title:
Need help getting started
Miscellaneous
Thread ID:
00457660
Message ID:
00457660
Views:
66
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
L.A.Long
ProgRes
lalong1@charter.net
Next
Reply
Map
View

Click here to load this message in the networking platform