FrontPage Database Connectivity

[jblaze]

Hello All.

I am having a very difficult time getting my FrontPage webpages to
connect to MS SQL Server and Access Databases.

-Our WebServer is running Windows 2003 Server STD and IIS 6.0.
-FrontPage 2003

The Databases that I am trying to connect to are on two seperate
servers. One of the servers is a win 2003 server and that has MS SQL
Server 2000 installed. The other is a Windows 2000 server installed
with Access from the Office XP Suite.

I would like to have my Intranet connect to the database so that users
can search and edit data directly. (e.g. adding or editing users in
our directory database.)

What is that best way to setup and test this??? I've been working on
this for two days now....and would think that Microsoft would make it
pretty easy to accomplish this task, but i'm about to pull out my
hair.

Any suggestions, instructions of caveats would be greatly appreciated.

Preemptive Thanks....

 

[Thomas A. Rowe]

As far as using Access, you only need to import the Access database into your current open web, and
the use the FP database components to connect to. Access the application is not needed on the
server.

However, if you are going to use Access data, which is going to be via using ASP, then you can not
also work with the database directly from with the Access Application at the same time.

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

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

 

[Jim Buyens]

Howdy.

The usual approach for SQL Server is to set up an account
and password within SQL Server, and then code those values
into the database connection or the connection string.

For access, the Web server and the file server need to be
in the same (or trusting) domains, you have to configure
the Web server to run under a domain account, you code the
database location as a UNC filename
(\\server\sharename\...), and you have to give the domain
account Change permission to that sharename. However, if
people are going to access the same database via the
Access desktop software, you'll almost certainly
encounter "file in use" problems on both platforms.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------