Confused on local vs host DB storage and connection

[jimt]

I'm using FP2000 and have the FP extentions turned on on both the localhost
and
the hosting system (which is great for a novice like me to handle document
control). I have a DB which is maintained and stored locally on another
computer
and networked over when enough changes are made to the DB for refreshing the
web
DB. The localhost DB is in a directory named FPDB under the inetpub\wwwroot
directory per FrontPage standards. The hosting system however REQUIRES the
DB to
be stored in a directory outside the /public directory named databases (all
the
web guru also indicates this is a good idea for security reasons).

1. How do I (FrontPage) get the DB from local FPDB directory to the not
under /public
"database" directory on the host. where all the other FP objects are stored

2. What setting in FP (tools/websettings) should be used?

3. What connection string (nonDSN) should be used in my ASP connection
include page? Are the connection string(s) different for local and web
connection, if so, do I have to kept separate string for testing purpose
against the local DB and then reset the string before I do the next publish?

As alway, thanks in advance for any help
Jim T.

 

[Thomas A. Rowe]

You would have to use the filesystem path to the database, which means you will need to keep two
files, one for your local system and one for the live system.

I use a System DSN to eliminate this issue, as it doesn't matter to the site where the database is
locate, as long as I use the same connection name for accessing the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[jimt]

Thanks, DSN is a new to me but we will give it a try. I'm assuming a DSN
should be set up on both the local and host system. Sorry, but another
question I have is what about the FPDB directory locally. If it remains under
the local web it will get published to the host /public directory which is
not what is desired. Should the local DB be stored in a "non localhost web"
directory?

Thanks again
Jim T.

 

[Thomas A. Rowe]

If you are going to use a System DSN, then you would store the database in another folder, which can
be anywhere on the machine, as long as it is the same machine as the web site.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[jimt]

Thanks for your help.
Jim T.

If you are going to use a System DSN, then you would store the database in another folder, which can
be anywhere on the machine, as long as it is the same machine as the web site.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================