| David Lee 2003-03-25, 7:23 am |
|
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
|