ASP Page Doesn't Display
I copied the following code from the book and tried to view it in my browser but got the following error:
"Microsoft Jet Database engine cannot open file '(unknown)'
Database is already opened exclusively by another user or you
need permission to view its data."
Can someone please tell me how to resolve this?? Thanks.
<%@Language=VBScript%>
<html>
<head>
<title>Home Page</title>
</head>
<body>
<p>This line from HTML</p>
<p>Next line from ASP will work<br>
if ASP extensions installed correctly:<br>
<%
response.write "<b>From ASP</b>"
%>
<p>Next line from ADO will work if a DSN named sailors has been set<br>
for the database which is named SAILORS.MDB.</p>
<%
set oRS=server.createobject("ADODB.recordset")
oRS.open "Select * from People", "DSN=sailors"
oRS.movefirst
response.write "<b>" & oRS("PeopleNameLast") & "</b>"
%>
Finished test page</p>
</body>
</html>
|