In these situations, I create the System DSN on the hosted site via a
control or via the host tech support, then using the same name for the
database and connection, etc, then I use the FP database option to create
the global.asa file locally with the required connection info. Then after
publishing open the live site in FP, and check/verify the connection.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
Richard said:
Does FP 2003 allow the direct entry of a DSN? If you are on a Shared
Hosting site, the web server admin will not allow FrontPage to display the
server data sources so you can select the one you setup.