Database Coneection

[Guest]

I am unable to create a connection to a database using an existing
connection. I have imported the database to the fpdb folder, created and
verified the connection. When I go to insert the database I get this 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/Update_ iod_wc_2000.mdb.

I am currently working on everything on my workstation, so there should not
be any hosting issues. Any advise? Thanks

Bill Beshlian

 

[Mark Fitzpatrick]

A workstation can run into the exact same issues as a hosted solution.
Usually this involves permissions. If you're running on a computer with an
NTFS file system, you may need to adjust the permissions for the _fpdb
folder. First though, you could try running a check and fix on the
extensions through the extensions admin and a recaluclate hyperlinks. This
may reset the permissions on the database. Basically, the anonymous internet
user account (IUSR) will need read/write/delete permissions on your database
file to update/insert to it. Even though you are logged in with a specific
NT user account, IIS will often still authenticate with the IUSR account
first, mostly because the generic User or Everyone group will have read
access, and the IUSR account is present within those groups.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage