I've written a simple ASP script to print news articles from an access
database. It works fine on and NT4/IIS4.0 system, but only gives me 500
Internal Error on a Win2k/IIS5.0 server. Is there an error log somewhere I
can look at? I'm confused!! Can anyone shed any light as to why this won't
work?

code follows:

<%
Dim AccessDatabase
Dim NewsRS
Dim PathToDatabase

PathToDatabase = "c:\siteDB.mdb"

Set DB = Server.CreateObject("ADODB.Connection")
DB.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & PathToDatabase)
Set NewsRS = Server.CreateObject("ADODB.Recordset")
NewsRS.Open "SELECT * FROM News", DB

NewsRS.Movefirst

do while not NewsRS.EOF
%>

<font size=2><B><U>
<% Response.Write NewsRS("ArticleText") %>
</U></B><BR>
<% Response.Write NewsRS("PostedBy")%>
<BR><BR>
<% NEwsRS.MoveNext %>

<% loop %>

thanks!

dave

Report this post to a moderator

sorry, wrong group!

Report this post to a moderator