Database connection error in FP2003

T

Thoughtcat

I'm running Office 2003 on Windows XP Pro. I have designed a database
in Access 2003 and want to design a website using FP2003 where users
can retrieve selected information through the page from that database.
I have tried several times to set up a database connection on FP but
have had no luck. When trying insert/database/data view or data/insert
data view, I get this message: "The FP Data View features can only be
used on servers running Windows SharePoint Services. If you do not
have a Web site hosting service, find one that supports FP or WSS by
using the Web Presence Provider." However, I do have a web site
hosting service that supports FP.

Next, when I try insert/database/results and go through the ensuing
wizard, I always get the following error message, even when using the
built-in sample "Northwind" database:

Database connection error

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

Source: ADO
Number: -2146824584 (0x800a0e78)


I have tried detect & repair but there's no change. As I say, my web
host supports FP extensions so that can't be at fault. I had this
problem with FP2002 as well, and switched to Office 2003 partly to try
and resolve this. Any ideas?

Many thanks,
Frustrated of London
 

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