database result: button dimmed

G

Guest

Using FP2003 and access database. I have created the database and
successfully connected to it running on IIS on XP pro. Now I need to
retrieve data from the database. PROBLEM: When I go to
Insert:Database:Results to begin designing a query, the results button is
dimmed. I've looked through several post and tried various suggestions but
nothing has worked. On tools:site options: database I do have a verifed
connection. Any help will be greatly appreciated
 
S

Steve Easton

Close FrontPage.

Right click My computer, Select Manage.
When the management console opens, click the plus signs by Internet
Information Services, and Default Web site.

Right click on the folder that contains your database web, and select
"Properties."

In the dialog that opens, click the Directory tab ( if it doesn't
automatically open there )

On the directory tab there is an "Applications" section.
Opposite the Application name section, click the "Remove" button.
When it's done, the remove button turns into a "Create" button.
Click it, and the folder name for your database web should appear in
"Application name."

Then click "Configuration" and the Mapping dialog will open.

For .asp:
Scroll down to .asp, click to select it and click "Edit" and the ADD/Edit
Application Extensions Mapping dialog will open.

Make sure "Executable" points to: C:\WINDOWS\system32\inetsrv\asp.dll
and that under Verbs that "Limit to" is checked and the text box contains:
GET,HEAD,POST,TRACE

For asp.net: ( noted by the pages having the .aspx extension )

Scroll to the .aspx listing. If not there click Add and
Make sure "Executable" points to: C:\WINDOWS\Microsoft.NET\Framework\"the
version installed on your machine"\aspnet_isapi.dll
and that under Verbs, that "Limit to" is checked and that the text box
reads: GET,HEAD,POST,DEBUG

Click Apply and or OK all of the way out.

Restart IIS and then reopen your web.

You can restart IIS by right clicking Internet Information Services,
scrolling to "All Tasks" and selecting Restart.

Many thanks to Thomas Rowe who walked me through this over the phone one
day.

hth

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top