Database Won't Open

[Earl Partridge]

FrontPage 2000, Access 2000, Windows XP Pro
Using an .asp page to retrieve data from my database... on my local machine,
when I Preview in Browser, I get the html code. I Refresh and get the
normal page, but no data. My .mdb file exists and is correctly identified
in
ODBC. IIS has been stopped and restarted.

With this same page on my host's server, it works as expected.

 

[Steve Easton]

Make sure you are viewing the page using
http://localhost/webname/pagename.asp
or
http://UserName/webname/pagename.asp

UserName being the user name that is logged onto the machine.

in my case it would be
http://Steve/webname/pagename.asp


Also, did you open the Management Console, click the pluses by IIS, Web
sites, and Default Web Site, then right click the folder containing your
database, click properties and then set / reset the Application Name: ??
It should be the same as the folder name that contains the database.


--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer

 

[Earl Partridge]

Need a little clarification... localhost/webname/pagename.asp, afraid I
don't
know what to use for "webname". my page resides under
inetput/wwwroot/mycopyname/myfoldername/default.asp
would I use that as my "webname"?

Also, for Management Console, in XP Pro, I go to Control Panel | Admin Tools
|
Internet Information Services, then +Computer Name, +Web Sites,
+Default Web Site. Clicking this last + I see my folders but not the "DB"
folder
containing the database. I click the "Default Web Site" (not the +) and the
folders
appear in the right pane, and the database file is there... but not the "DB"
folder
in which it resides.
Earl

 

[Steve Easton]

In line:

Need a little clarification... localhost/webname/pagename.asp, afraid I
don't
know what to use for "webname". my page resides under
inetput/wwwroot/mycopyname/myfoldername/default.asp
would I use that as my "webname"?

Ok, on my machine under the XP partition I have a database and related pages
that live in a ( web ) folder named: dbtest

The file path in explorer is C:\Inetpub\wwwroot\dbtest

To open it in the browser the path is: http://localhost/dbtest/default.asp
or
http://steve/dbtest/default.asp

And actually if default.asp is set as the default document for the web in
IIs all that is required is http://localhost/dbtest
or http://Steve/dbtest

Also, for Management Console, in XP Pro, I go to Control Panel | Admin
Tools |
Internet Information Services, then +Computer Name, +Web Sites,
+Default Web Site. Clicking this last + I see my folders but not the "DB"
folder
containing the database. I click the "Default Web Site" (not the +) and
the folders
appear in the right pane, and the database file is there... but not the
"DB" folder
in which it resides.
Earl

Click the plus by default web site.
Then right click the folder that contains default.asp.

What is the name of the default page for your database interface??
In my case it is Default.asp which was automatically created when I made the
database.
Whichever "folder" this page lives in is your Application root and should be
the "Application name" when you right click the folder and select
properties.

hth

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer

 

[Earl Partridge]

Further... In FP I went to Tools | Web Settings | General and in the
section
Server Version: it shows "No Server Currently in Use"..
As far as I am aware, I have done everything I know how to assure that IIS
is running.
Earl

 

[Steve Easton]

You need to have the IIS based web open in FP to see server properties.
Are you opening http://username/webname in FrontPage??

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer

 

[Earl Partridge]

Yes, using FP's Preview in Browser...
Earl

You need to have the IIS based web open in FP to see server properties.
Are you opening http://username/webname in FrontPage??

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
.......................with a computer

 

[Earl Partridge]

Sorry to be so dense... but, I can't get there with localhost. The actual
true
location of the web folder is c:\inetpub\wwwroot\atlcon-copy\gmarc and the
file is default.asp. I tried the full path, and also assuming that
inetpub\wwwroot
is FP's default location, tried without the full path... still won't locate
it.

And in the Admin Tools, when I right click the web folder, the drop down
menu
shows: Browse | All Tasks | View | Help. No "Properties" option.

I also read http://support.microsoft.com/kb/219159/en-us , did what it
suggested
and that did not change anything.

Earl

 

[Steve Easton]

You're not dense at all Earl.
;-)
We might have to post back and forth a few times to get this right, so be
patient.

c:\inetpub\wwwroot\atlcon-copy\gmarc tells me that gmarc is a subweb to
atlcon-copy.
So, the following "should work."

1st. right click My computer and click Manage.
In the panel that opens, click the plus signs by Services and Applications >
IIS > Websites > Default Web Site > atlcon-copy

Right click on gmarc and select properties.
The dialog that opens should read gmarc Properties on the very top title
bar.
Click the "Directories" tab. ( if that's not the one that opens by default )
Under "Application Settings" the Application Name: should read: gmarc
If not, click the Remove button opposite "Application Name" and the button
will change to create
Click it and the Application Name: should change to: gmarc

If so, click Apply and then OK.

Then click the plus by Local users and groups.
Then click Users.
In the right panel right click IWAM_UserName ( username being the one you
log onto the computer with )
Select Properties and in the dialog that opens click Member Of.
It should list: Administrators
If not, click Add and add the Administrators account.

Then either Reboot or:
Right click Internet Information Services, scroll to All Tasks and click
"Restart IIS."

Personally, I would Reboot the machine.


--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer