database connections

[Guest]

Hi

I have reached the point where I am looking to integrate the access databases I use with a basic intranet site set up in FP

Can I just check the process of setting up a database connection? As its only a small intranet rather then the www, with around 30 users running on a network, I've gotten as far as going to Tools > Web Settings and then select "database" and "Add...

From there should I be selecting "Network connection to database server"? If so, where can I find out what the Server Name is? (without asking my IT manager which will lead to 20 questions about why I'm asking...) Also - the database name - would this be the full path off the database eg i:\access databases\gbinfo.mdb

Cheers for any pointers
Iain

 

[Guest]

Hi

If you are selecting "Network Connection to database server", you need an SQL or Oracle database Server running on the network. If you have an SQL server running on the box where the web site is hosted, you can give the name of that here. You can use the Database results Wizard which will guide you through the process of creating a database. In the Web site templates section you can find the wizard

regard

Harikuma

----- Iain wrote: ----

Hi

I have reached the point where I am looking to integrate the access databases I use with a basic intranet site set up in FP

Can I just check the process of setting up a database connection? As its only a small intranet rather then the www, with around 30 users running on a network, I've gotten as far as going to Tools > Web Settings and then select "database" and "Add...

From there should I be selecting "Network connection to database server"? If so, where can I find out what the Server Name is? (without asking my IT manager which will lead to 20 questions about why I'm asking...) Also - the database name - would this be the full path off the database eg i:\access databases\gbinfo.mdb

Cheers for any pointers
Iain

 

[Tom Miller]

An important question is where is the Access database going to reside? If
it resides on the same machine the Intranet server lives on, then you don't
need a "network" connection. That is about the extent of my knowlege,
unfortunately. I am still trying to get time to experiment somemore with
this stuff.

The FP help has a lot of information on using the builtin database features
of FP, but I like Buyens "Frontpage, Inside Out" better.

Tom

Hi,

I have reached the point where I am looking to integrate the access

databases I use with a basic intranet site set up in FP.

Can I just check the process of setting up a database connection? As its

only a small intranet rather then the www, with around 30 users running on a
network, I've gotten as far as going to Tools > Web Settings and then select
"database" and "Add..."

From there should I be selecting "Network connection to database server"?

If so, where can I find out what the Server Name is? (without asking my IT
manager which will lead to 20 questions about why I'm asking...) Also - the
database name - would this be the full path off the database eg i:\access
databases\gbinfo.mdb ?

Cheers for any pointers,
Iain

--
+++++++++++
I provide computer tech support for North East Kansas: www.bluecollarcc.com
100,000's of files are at: www.chatnfiles.com
Some the best free Website creation training on the Web at:
www.w3schools.com

 

[Guest]

basically nothing is local to my pc - both the existing databases in Access and the intranet (its not even really an intranet, its just a frontpage web stored on the shared disk space on the server) are on a shared server (windows 2k pro)

or at least thats how I understand it, although I'm not too clued up on the ins and outs of networks and servers

so basically I'd like to connect the Access databases to the FrontPage stuff - mainly because the databases can be a bit slow off the server, and some of the data replicated in a browser will make a handy look up tool for colleagues that don't need all the functionality of the databases

Iain

 

[Thomas A. Rowe]

The site needs to be hosted on under IIS (Web server)

--

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

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

basically nothing is local to my pc - both the existing databases in

Access and the intranet (its not even really an intranet, its just a
frontpage web stored on the shared disk space on the server) are on a shared
server (windows 2k pro).

or at least thats how I understand it, although I'm not too clued up on

the ins and outs of networks and servers.

so basically I'd like to connect the Access databases to the FrontPage

stuff - mainly because the databases can be a bit slow off the server, and
some of the data replicated in a browser will make a handy look up tool for
colleagues that don't need all the functionality of the databases.

 

[Thomas A. Rowe]

In order to connect to the database you must use ASP, and that requires a
web server and that page are accessed via http://

--

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

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

basically nothing is local to my pc - both the existing databases in

Access and the intranet (its not even really an intranet, its just a
frontpage web stored on the shared disk space on the server) are on a shared
server (windows 2k pro).

or at least thats how I understand it, although I'm not too clued up on

the ins and outs of networks and servers.

so basically I'd like to connect the Access databases to the FrontPage

stuff - mainly because the databases can be a bit slow off the server, and
some of the data replicated in a browser will make a handy look up tool for
colleagues that don't need all the functionality of the databases.

 

[Jim Buyens]

Hi,
Howdy.

I have reached the point where I am looking to integrate the access
databases I use with a basic intranet site set up in FP.

Can I just check the process of setting up a database connection? As its
only a small intranet rather then the www, with around 30 users running on a
network, I've gotten as far as going to Tools > Web Settings and then
select "database" and "Add..."

From there should I be selecting "Network connection to database server"?
If so, where can I find out what the Server Name is? (without asking my IT
manager which will lead to 20 questions about why I'm asking...) Also - the
database name - would this be the full path off the database eg i:\access
databases\gbinfo.mdb ?

Normally, for an Access database, you physically locate the database
within its own folder in the Web site. Then, when you set up the
database connection, you choose File Or Folder In Current Web Site.

If your database is going to physically reside on a different machine,
you can either:
o In Windows, define an ODBC System Data Source Name on the Web
server.
Then, in the New Database Connection dialog box, select System Data
Source On Web Server
o Click Custom Definition, and then click the Advanced button, Then,
in the Connection String dialog box, type something like:
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\server\share\folder\db.mdb;

(The option Network Connection To Database Server, BTW, is for SQL
Server or Oracle databases.)

Also, in IIS Manager, you'll need to configure a virtual directory at
the start of your FrontPage Web, mark it as an IIS Application, and
configure the anonymous account to be a domain account with:
o Permission to update the folder containing the database.
o Permission to read the contents of the FrontPage Web.
o The Log On Locally user right on the Web server.

Having done all this, the Save Results To Database component, the
Database Results Wizard, and the Database Interface Wizard will be
able to use the database. Any forms and reports you defined within the
Access database, however, won't work over the Web. If you want any
sort of database processing beyond the built-in FrontPage components,
you'll need to write your own ASP or ASP.NET code.

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

 

[Guest]

Hi,

Thanks for all that - sounds like it might get a bit complicated.

I've actually gotten it doing everything it needs to do (its only really replicating lists of information) using
the Data Access Pages in Access, so I might leave it be for the moment.

Iain