|
 |
access_asp thread: Can't Access .asp file
Message #1 by "Furqan Iqbal" <kinara0786@h...> on Wed, 5 Jun 2002 03:25:19
|
|
Hi,
I am learning javascript using p2p Begining Javascript, there is a
chapter on databases and accessing them using ASP, well, I did everything
the book said, now the problem is that, I can't access my .asp file from
the internet, why is that? when I type the url, it says internal server
err 500, the page cannot be displayed, its on the site, the .mdb is on
the site, can someone please help me with that?
the URL is
www.inv-network.com/futuresite/database/displaymembers.asp
Following is the code for the .asp file, please check for errs, I can't
figure out what the deal is.
<%@ language = Javascript%>
<html>
<body>
<Table border=1 height="53">
<Thead>
<tr>
<th height="19">N A M E</th>
<th height="19">C I T Y</th>
<th height="19">W E B S I T E</th>
</tr>
</thead>
<%
var adoConnection = Server.CreateObject("ADODB.Connection");
var adoRecordSet;
var mySQL;
adoConnection.Open("DSN=isnmembers");
var mySQL = "SELECT name, city, url FROM memberinfo";
adoRecordSet = adoConnection.Execute(mySQL);
while ( adoRecordSet.Eof == false )
{
%>
<tr>
<td><%=adoRecordSet.("name").Value%></td>
<td><%=adoRecordSet.("city").Value%></td>
<td><%=adoRecordSet.("url").Value%></td>
</tr>
<%
adoRecordSet.MoveNext();
}
adoRecordSet.Close();
adoRecordSet.Null();
adoConnection.Close();
adoConnection.Null();
%>
</Table>
</body>
</html>
it is saved as an asp file, please take a look at it, and help me find
out why is this happening ?
thanx
Kinara
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 5 Jun 2002 13:19:16 +1000
|
|
http://www.inv-network.com/futuresite/database/displaymembers.asp
works fine for me.
On your computer I suggest you open Internet Explorer, and go to Tools |
Internet Options | Advanced and uncheck the box that says "show friendly
HTTP errors".
Then post the exact error message that you receive to the list.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Furqan Iqbal" <kinara0786@h...>
Subject: [access_asp] Can't Access .asp file
: I am learning javascript using p2p Begining Javascript, there is a
: chapter on databases and accessing them using ASP, well, I did everything
: the book said, now the problem is that, I can't access my .asp file from
: the internet, why is that? when I type the url, it says internal server
: err 500, the page cannot be displayed, its on the site, the .mdb is on
: the site, can someone please help me with that?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
