This topic is locked

Location of Database

6/26/2003 9:06:29 AM
ASPRunnerPro General questions
author

All of my databases for my frontpage web are in \fpdb. When I create an asp I make a new directory and paste the contents of the output folder to that new directory and everthing works well. I am now getting some requested to do a couple view only pages from this database. Frontpage will only post a data page from the results of a database in the /fpdb directory. Finally my question, I have tried to change <%strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (.mdb)};DBQ=" & server.mappath("db\Portable_Reports.mdb") & ";UID=;PWD="

%> in the aspconnection.asp file to read <%

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (
.mdb)};DBQ=" & server.mappath("db\fpdb\Portable_Reports.mdb") & ";UID=;PWD="

%> and I get a fauilure to open registry error. What can I do to fix this? Also when you new version come out I definatly have the need for dropdown boxes. WIll there be a charge to upgrade? Thanks Jerry

Sergey Kornilov admin 6/29/2003

Hi,
If your ASP files go to /fpdb directory and your database resides in /fpdb/db directory your connection string should read:

<%strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("db\Portable_Reports.mdb") & ";UID=;PWD="%>


New version is coming out on August 1st and upgrade is free for existing users.
Best regards,

Sergey Kornilov