Directing my Forms in FP03 to my web hosts database

[Guest]

My web host provides a web database to store my Forms info. However, I am not clear on how to set it up in FP03
I go to Forms Properties and select "send to database", then I select "Options", and name a "Database Connection to Use", Database1. In "database connection properties" there is a selection. Which do I select? Is what I'm trying to do, is it: Network Connection to Database Server? or System Data Source on Web Server? Am I on the right track? Or have I done this all wrong? Once I make a selection I type in the URL? Thank you. Any assistance would be greatly appreciated.

 

[Thomas A. Rowe]

You have to get the required info from your host.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

My web host provides a web database to store my Forms info. However, I am not clear on how to set it up in FP03.
I go to Forms Properties and select "send to database", then I select "Options", and name a

"Database Connection to Use", Database1. In "database connection properties" there is a selection.
Which do I select? Is what I'm trying to do, is it: Network Connection to Database Server? or System
Data Source on Web Server? Am I on the right track? Or have I done this all wrong? Once I make a
selection I type in the URL? Thank you. Any assistance would be greatly appreciated.

 

[Thomas A. Rowe]

You need to set up the connection under Tools | Site Settings | Database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

My host can't instruct my on the FP03 ins and outs. I have the info string from the host, now I

need guidance on the FrontPage side.

How do I proceed in FrontPage where it says "send to database". Can someone tell me if I'm on the

right track?

 

[xfile]

Hi:

This is for what I have done for your reference.

(1) Move your database file to hosting service folder and create a DSN (or
DSN-less) connection at your hosting service. This allows your pages stored
at your hosting service folders to assess the database connection to the
database file in their folder. You need to check with them for if and how
to set up that connection and where to put the database folder.

(2) You can edit your page with opening the site at hosting service and then
create database link to the connection made in (1). Alternatively, I set up
a testing local site mimic the hosting service and do the development work
before moving them to hosting site. But my local environment is not exactly
the same as the hosting environment so I often encountered some minor
problems, in which case, doing directly in the hosting environment seems to
be the best way for my case.

However, we will try to set up a real local server environment in the future
to avoid that practice.

Good luck!!!