Access database and frontpage

[dp5097]

I am new to using Frontpage and Access and would like some advice. I have
created an intranet site fro the school no problems, but I have also created
a database to keep track of the ICT rooms and their bookings. The data access
page I have incorporated into a front page page and it works well run locally
as it picks up the database from my machine, but when I publish it to the
server I get the form but not the information conatined within the database.
I get the message abou needing to install web componants, but I cannot find
them anywhere. Help please, before I go any greyer.

 

[Kathleen Anderson [MVP - FrontPage]]

Are you publishing to a Windows server that supports ASP and Access?

What is the exact text of the error message? What web components?

 

[CodeBubba]

In order to use Access (or SQL Server) from FrontPage, your database must be
referenced using what's called a DSN (Data-Set-Name). In both cases (your
local machine) and the server to which you publish a DSN must exist so your
ASP code (or DataResults Wizard) knows where to find your Access file.

I'm using FP2002 with Access2002 myself. Being a developer it didn't take
me long to figure out how to do this - however to someone not familiar with
databases there are a number of books on the subject. Pick up a copy of
"Microsoft Front Page 2002 Unleashed" at your local bookstore, you should
still be able to find a copy. (If you're using an earlier version of
FrontPage you might want to upgrade to 2002 (XP)). There are sufficient
details in the book to help you get up to speed on this. Making a database
work with FrontPage takes a little bit of work but is not that hard once you
get the routine.

HTH,

-bruce

 

[Jens Peter Karlsen[FP MVP]]

If they are going to upgrade, they should upgrade to FP2003 which is
much better than FP2002.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: CodeBubba [mailto:[email protected]]
Posted At: 28. november 2004 02:57
Posted To: microsoft.public.frontpage.programming
Conversation: Access database and frontpage
Subject: Re: Access database and frontpage


In order to use Access (or SQL Server) from FrontPage, your
database must be referenced using what's called a DSN
(Data-Set-Name). In both cases (your local machine) and the
server to which you publish a DSN must exist so your ASP code
(or DataResults Wizard) knows where to find your Access file.

I'm using FP2002 with Access2002 myself. Being a developer
it didn't take me long to figure out how to do this - however
to someone not familiar with databases there are a number of
books on the subject. Pick up a copy of "Microsoft Front
Page 2002 Unleashed" at your local bookstore, you should
still be able to find a copy. (If you're using an earlier
version of FrontPage you might want to upgrade to 2002 (XP)).
There are sufficient details in the book to help you get up
to speed on this. Making a database work with FrontPage
takes a little bit of work but is not that hard once you get
the routine.

HTH,

-bruce

I am new to using Frontpage and Access and would like some advice. I
have created an intranet site fro the school no problems, but I have
also created a database to keep track of the ICT rooms and their
bookings. The data access page I have incorporated into a front page
page and it works well run locally as it picks up the database from
my machine, but when I publish it to the server I get the form but not
the information conatined within the database.
I get the message abou needing to install web componants, but I cannot
find them anywhere. Help please, before I go any greyer.

 

[Kevin Spencer]

In order to use Access (or SQL Server) from FrontPage, your database must
be

referenced using what's called a DSN (Data-Set-Name).

1. The basic content of the statement is not true. A DSN is not necessary to
connect to a database. It is one of several ways to connect. The best way to
connect is through OLE DB (Object Linking and Embedding for Databases),
which ODBC (A DSN is a connector for ODBC - Open Database Connectivity) is
a wrapper for. Actually, if using ASP.Net, and if using SQL Server, the
native .Net SQL Provider is faster than OLE DB.

2. "DSN" is an acronym for "Data Source Name."

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.