When navigating my website, I get the error listed below instead of the page I want. If I wait a few minutes and refresh, I get the page just fine - although, if the page includes a file that accesses the db, I usually have to wait, refresh, wait, refresh before the page comes up. In each case, (on each page) the error points to the line where I am connecting to the Access database (cn.Open "DSName"
.
After running IE update on the Win2K server, everything worked fine. Once I loaded all the security updates, the problem returned - and remains even after installing the same updates on the Win2K client.
Any ideas?
ERROR:
HTTP 500.100 - Internal Server Error - ASP error
Error Type:
Provider (0x80004005)
Unspecified error
/folder/page.asp, line 28
CODE:
<%@ Language = VBscript %>
<html><head>
<!-- #include file ="style.inc" -->
<title>Title Is Here</title>
<!-- #include file ="menu.inc" -->
</head>
<body bgcolor="#FFFFFF" text="#000000" style="font-family: Arial; font-size: 10">
<table width="100%" bgcolor="#808080"><tr style="color: #FFFFFF; background-color: #000080;">
<%
set cn = Server.CreateObject("ADODB.Connection"
cn.Open "DSName"
strSQL="SELECT * FROM table ORDER BY AnID"
Set rs = cn.Execute(strSQL)
For i = 0 to rs.Fields.Count -1
Response.Write "<td>" & rs(i).Name & "</td>"
Next
response.write "</tr>" & VbCrLf
while not rs.EOF
response.write "<tr>"
For i = 0 to rs.Fields.Count -1
if rs(i).Name = "AnID" then
response.write "<td><a href='anotherPage.asp?AnID=" & rs(i).Value & "'>" & rs(i).Value & "</a></td>"
Else
response.write "<td>" & rs(i).value & "</td>"
End if
Next
response.write "</tr>" & VbCrLf
rs.movenext
wend
rs.close
set rs=nothing
cn.close
set cn=nothing
%>
</table></body></html>
.After running IE update on the Win2K server, everything worked fine. Once I loaded all the security updates, the problem returned - and remains even after installing the same updates on the Win2K client.
Any ideas?
ERROR:
HTTP 500.100 - Internal Server Error - ASP error
Error Type:
Provider (0x80004005)
Unspecified error
/folder/page.asp, line 28
CODE:
<%@ Language = VBscript %>
<html><head>
<!-- #include file ="style.inc" -->
<title>Title Is Here</title>
<!-- #include file ="menu.inc" -->
</head>
<body bgcolor="#FFFFFF" text="#000000" style="font-family: Arial; font-size: 10">
<table width="100%" bgcolor="#808080"><tr style="color: #FFFFFF; background-color: #000080;">
<%
set cn = Server.CreateObject("ADODB.Connection"
cn.Open "DSName"
strSQL="SELECT * FROM table ORDER BY AnID"
Set rs = cn.Execute(strSQL)
For i = 0 to rs.Fields.Count -1
Response.Write "<td>" & rs(i).Name & "</td>"
Next
response.write "</tr>" & VbCrLf
while not rs.EOF
response.write "<tr>"
For i = 0 to rs.Fields.Count -1
if rs(i).Name = "AnID" then
response.write "<td><a href='anotherPage.asp?AnID=" & rs(i).Value & "'>" & rs(i).Value & "</a></td>"
Else
response.write "<td>" & rs(i).value & "</td>"
End if
Next
response.write "</tr>" & VbCrLf
rs.movenext
wend
rs.close
set rs=nothing
cn.close
set cn=nothing
%>
</table></body></html>