T
Thoughtcat
Hi,
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 (if it has
anything to do with it). I have tried using FP online help but all I
seem to get from that are about 300 results, not all of which are
anything to do with database connection errors! Can anyone point me in
the right direction?
Many thanks,
Frustrated of London
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 (if it has
anything to do with it). I have tried using FP online help but all I
seem to get from that are about 300 results, not all of which are
anything to do with database connection errors! Can anyone point me in
the right direction?
Many thanks,
Frustrated of London