Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: beginner question


Message #1 by "Denise Robinson" <denise@i...> on Fri, 31 Aug 2001 09:48:20 -0400
Hello, esteemed listers.  I'm new to list - driven here by complete

frustration and a feeling of helplessness.  <smile>  I'm an access database

programmer (also very comfortable with HTML) who is trying to convert her

website from a standard HTML site to an informative ASP site.



I took a course in ASP many months ago on a Windows 98 machine.  I knew it

would take some time puttering about to get comfortable with ASP again after

so

long, but now my laptop is a Windows 2000 machine and I can't seem to even

get started.



All the files are being run locally so that I can re-design the entire site

using ASP.



I've got my directory showing up in IIS under the Webpub folder and IIS is

running.   The .asp help files that ship with Windows are visible, so I know

the asp

stuff is installed correctly.



I know I must be missing something obvious, but I can't seem to find any

help.  Any suggestions?



Thanks so much for your time.

Denise Robinson



PS - I'm on digest, so cc's to my email would be appreciated.

denise@i...





Message #2 by "Michael Kent Simmons" <msimmons@u...> on Fri, 31 Aug 2001 11:41:33 -0300
Denise:



What exactly is happening when you put a .asp file into the server's root

directory and try to run it? What's the error you're getting? That can help

lead us to the source of the difficulty.



Michael





----- Original Message -----

From: "Denise Robinson" <denise@i...>

To: "Access ASP" <access_asp@p...>

Sent: Friday, August 31, 2001 10:48 AM

Subject: [access_asp] beginner question





> Hello, esteemed listers.  I'm new to list - driven here by complete

> frustration and a feeling of helplessness.  <smile>  I'm an access

database

> programmer (also very comfortable with HTML) who is trying to convert her

> website from a standard HTML site to an informative ASP site.

>

> I took a course in ASP many months ago on a Windows 98 machine.  I knew it

> would take some time puttering about to get comfortable with ASP again

after

> so

> long, but now my laptop is a Windows 2000 machine and I can't seem to even

> get started.

>

> All the files are being run locally so that I can re-design the entire

site

> using ASP.

>

> I've got my directory showing up in IIS under the Webpub folder and IIS is

> running.   The .asp help files that ship with Windows are visible, so I

know

> the asp

> stuff is installed correctly.

>

> I know I must be missing something obvious, but I can't seem to find any

> help.  Any suggestions?

>

> Thanks so much for your time.

> Denise Robinson

>

> PS - I'm on digest, so cc's to my email would be appreciated.

> denise@i...

>

>

>

>

Message #3 by "Denise Robinson" <denise@i...> on Fri, 31 Aug 2001 11:32:07 -0400
The page opens and all the basic HTML stuff is visible, but anything that's

supposed to come from the ASP code doesn't show.



I originally tried this:



<%@ language="VBSCRIPT" %>

<% OPTION EXPLICIT %>

<html>

<head>

<title>Homepage</title>

</head>

<body>

<div align="center">

<table width="600">

<tr>

<!-- #INCLUDE file="includes/header.asp" -->

</tr>

<tr>

<td>

<!-- #INCLUDE VIRTUAL="Chandani/includes/navigate.asp" -->

</td>

<td width="450" valign="top">

Insert Copy Here

</td>

</tr>

</table>

</body>

</html>





When that didn't work, I tried this test my workbook suggested:



<%@ language="vbscript" %>

<% option explicit %>

<html>

<head>

<title></title>

</head>

<body>

<p>This line from html</p>

<HR>

next line from ASP will work<BR>

if ASP extensions installed correctly:<BR><b>

<%

Response.write "Magically appearing From ASP"

%></b>

<HR>

Next line from ADO will work if a DSN named moonlightdancer has been set<BR>

for the example database which is named moonlightdancer.mdb.

<%

Set oRS=Server.CreateObject("ADODB.recordset")

oRS.open "SELECT * FROM tblSiteList WHERE [title] like 'belly'",

"DSN=moonlightdancer"

oRS.movefirst

response.write "<b>" & ors("title") & "</b>"

%>

<HR>

finished test page

</body>

</html>

Thanks for your time.



Denise





----- Original Message -----

From: "Michael Kent Simmons" <msimmons@u...>

To: "Access ASP" <access_asp@p...>

Cc: <denise@i...>

Sent: Friday, August 31, 2001 10:41 AM

Subject: Re: [access_asp] beginner question





> Denise:

>

> What exactly is happening when you put a .asp file into the server's root

> directory and try to run it? What's the error you're getting? That can

help

> lead us to the source of the difficulty.

>

> Michael

>

>

> ----- Original Message -----

> From: "Denise Robinson" <denise@i...>

> To: "Access ASP" <access_asp@p...>

> Sent: Friday, August 31, 2001 10:48 AM

> Subject: [access_asp] beginner question

>

>

> > Hello, esteemed listers.  I'm new to list - driven here by complete

> > frustration and a feeling of helplessness.  <smile>  I'm an access

> database

> > programmer (also very comfortable with HTML) who is trying to convert

her

> > website from a standard HTML site to an informative ASP site.

> >

> > I took a course in ASP many months ago on a Windows 98 machine.  I knew

it

> > would take some time puttering about to get comfortable with ASP again

> after

> > so

> > long, but now my laptop is a Windows 2000 machine and I can't seem to

even

> > get started.

> >

> > All the files are being run locally so that I can re-design the entire

> site

> > using ASP.

> >

> > I've got my directory showing up in IIS under the Webpub folder and IIS

is

> > running.   The .asp help files that ship with Windows are visible, so I

> know

> > the asp

> > stuff is installed correctly.

> >

> > I know I must be missing something obvious, but I can't seem to find any

> > help.  Any suggestions?

> >

> > Thanks so much for your time.

> > Denise Robinson

> >

> > PS - I'm on digest, so cc's to my email would be appreciated.

> > denise@i...

> >






  Return to Index