FP2000 problems with Database importing.

[John]

Hi,

I'm getting this error when trying to set up a Database file on a ASP page.

What's going on please, any assistance apppreciated.

John.

Database Connection Error.

Server error: Unable to connect to a database from the web server using the
connection string 'DRIVER={Microsoft Excel Driver
(*.xls)};DBQ=URL=fpdb/Pricelist.xls'.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
The specified procedure could not be found.



Source: ADO
Number: -2147024769 (0x8007007f)

 

[Kathleen Anderson [MVP - FP]]

Hi John:
Excel is not a database, it's a spreadsheet. If you want to use an Excel
file as a data source, see this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;268948&Product=fp2000

 

[MD Websunlimited]

It is not a good idea to use Excel as a data source. Import the data into an Access database.

 

[John]

Hi Again, I have tried a number of varients even starting a new web from
scratch, but I am still getting the error when I use any format database
for importing?
Do you think it might be corruption in the FrontPage program itself ?
I tried reinstalling, but still has a problem. Any further assistance
appreciated.

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/WebsitePriceList.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.

 

[Kathleen Anderson [MVP - FrontPage]]

John:
How did you import the database into your web site? Try this:
http://www.spiderwebwoman.com/tutorials/create_dbc.htm

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/