Re: Database error

From: Sandra (anonymous_at_discussions.microsoft.com)
Date: 09/06/04 

Date: Mon, 6 Sep 2004 09:01:48 -0700

I don't understand. I thought I could test by publishing
to my web site, without having IIS installed.

 BUT I'M NOT TRYING TO TEST at this time. I'm just
trying to create the form. I follow the steps from
www.microsoftfrontpage.com/content/articles/datintro.html.
 I go through all the steps including,

 "Click the Create Database button. FrontPage will create
a new Access database as well as the database connection
in global.asa that you can use for later reference to
that database."

Then it says, "Click OK button in the lower right-hand
corner of the Options for Saving Results to Database
dialog"

When I do that it tells me "A valid database table is
required." If I cancel and go back, then click on
Options of the Form Properties dialog box again, I get
the original error message I wrote about.

>-----Original Message-----
>Do you have FP configured to use IIS, ASP and VBScript
under the Page Options | Compatibility or
>Page Authoring.
>
>When testing you must test via
http://localhost/pagename.asp in your browser, which
requires that
>you have Windows 2000 Pro / Windows XP Pro installed
with IIS and Extensions
>
>--
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage
support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Sandra" <anonymous@discussions.microsoft.com> wrote in
message
>news:683701c493ab$ac4cc6e0$a301280a@phx.gbl...
>> The microsoft url below talks about solving the problem
>> if you are using IIS. I am not. I'm just trying to
>> create a form to publish to the web site. But it will
>> not let me create it. I just get this error message.
>>
>>
>> >-----Original Message-----
>> >FP: Server Error: Unable to Retrieve the List of
Record
>> Sources from a
>> >Database Using the Connection String
>> >http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;276502
>> >
>> >
>> >--
>> >~ Kathleen Anderson
>> >Microsoft MVP - FrontPage
>> >Spider Web Woman Designs
>> >http://www.spiderwebwoman.com/resources/
>> >
>> >
>> >Sandra <anonymous@discussions.microsoft.com> wrote:
>> >> In trying to create a form that sends results to a
>> >> database, I get this error message when I choose a
>> >> database connection at the Options menu: "The server
>> >> encountered an error...." And then when I
>> click "details"
>> >> I get this:
>> >>
>> >> "Server error: Unable to retrieve the list of record
>> >> sources from a database using the connection string:
>> >>
>> >> DRIVER={Microsoft Access Driver
>> >> (*.mdb)};DBQ=URL=fpdb/left.mdb.
>> >>
>> >> The following error message comes from the database
>> >> driver software; it may appear in a different
language
>> >> depending on how the driver is configured."
>> >>
>> >> What's the solution?
>> >> ---------------------------------------------------- 

---
>> >>
>> >>
>> >> Source: ADO
>> >> Number: -2146824584 (0x800a0e78)
>> >.
>> >
>
>
>.
>