Building my first ASP page

Wixiban · June 9th, 2006, 10:04 AM

I've entered the following code into my_first.asp as given on page 216 but the thing isn't working.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>My First ASP Document</title>
</head>

<body>
Today's date is <%= Date %> and the present time is <%= Time %>.
</body>
</html>

When I preview the page all I get displayed is

"Today's date is and the present time is ."

Also, when viewing the source code for the page the ASP code is still visible. What could be causing this error?

Thanks in anticipation for your help.

Wixiban

Imar · June 9th, 2006, 10:07 AM

Looks like the ASP is not parsed by a web server.

How do you browse to the page? As http://localhost/my_first.asp?
Or something like C:\SomeFolder\my_first.asp?

Also, does the page have an ASP extension?|

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Wixiban · June 9th, 2006, 10:23 AM

I browse remotely at

http://www.wixiban.co.uk/theCookingArea/my_first.asp
- hosted by clara.net

and locally at

C:\theCookingArea\my_first.asp

I am running Windows XP Home Edition so I don't have the Windows IIS system.

Imar · June 9th, 2006, 10:37 AM

Without IIS, you won't be able to browse the pages locally. You need a webserver to parse the ASP. Without such a parser, you'll only see the HTML.

The same applies to your host; apparently they don't support ASP, or haven't configured the server properly...

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Wixiban · June 9th, 2006, 11:11 AM

Ah well

Looks like I'll have to investigate clara.net for their ASP support and maybe also invest in Windows XP Professional.

Thanks for you quick responses Imar.

Imar · June 9th, 2006, 12:11 PM

Yeah, that's correct. If they do support ASP, they may need to enable it, or move your account to an ASP enabled server.

And indeed: Windows XP professional comes with IIS, so it allows you to run ASP pages locally.

Cheers.

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

DellTah · July 20th, 2007, 10:23 PM

Hi, I'm piggy backing off this topic because it has to do with thinking of a workaround for Windows XP Home Edition (without IIS)... I have XP Pro at work, but want to tweak at home. I'm wondering if I could establish a remote data service connection to work on at home?

My local site is set up then, to be on my machine (XP Home) at home, and remote site is via FTP. This connection to the site is fine. But if the database is connected through the remote site, can I make a RDS connection to access the mdb file via the internet?

I have not been successful so far. Would I have to go through my local ODBC setup from my machine at home in order to read/write to it?

Thanks,
d.t.

Imar · July 21st, 2007, 01:44 AM

No, that won't work without a VPN connection or something like that.

However, why don't you develop the database locally, and then FTP it to the remote server together with the rest of the site?

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

DellTah · July 21st, 2007, 11:02 AM

Thanks Imar, I'll bet the connection string would not work then because it wouldn't be going through the local server. (i.e. ...c:\inetpub\wwwroot\TheSoccerSite\Database\TheSo ccerSite.mdb;User Id=admin;Password=")

I tried using the url in its place but to no avail. And then I tried looking for the corresponding situation from the provided connection strings site.
So far without success. Which connection string would work if I will FTP the site with the database to the remote server via internet?

Thanks again,
d.t.

Imar · July 21st, 2007, 11:20 AM

It depends on the set up of your server. If you have the database in a folder in the root called Databases, you could try this:

...." & Server.MapPath("/Databases/TheSoccerSite.mdb") & ";User ....

This gets the physical path of the database based on its virtual path.

Whether this works depends on your ISP / remote server. Some let you do it; others place the database outside the root of the web site, or give you a DSN. You'll have to check their FAQs / support to see what they support.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.