Database error

[Sandra]

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?

 

[Kathleen Anderson [MVP - FrontPage]]

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

 

[Sandra]

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.

 

[Thomas A. Rowe]

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)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Andrew Murray]

you need IIS to connect a MDB (Access) database.

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.

 

[Sandra]

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

 

[Sandra]

I don't understand. I thought you could use any of the
FrontPage capabilities if you publish to a server using
FP extensions WITHOUT having IIS installed on your
computer. I'm using XP Home, so no possibility of IIS.
Any ideas as to how to create a database?