About working with data

Microsoft Office FrontPage 2003

Show All Show All

About working with data

By using Microsoft FrontPage to author your Web site, you can add data from a variety of data sources. The tools you use to add data to your Web site depend on the types of available data sources, the operating system running on your Web server, and the server technology.

You can create a data-enabled Active Server Pages (ASP) or ASP.NET site or a data-driven Web site.

ShowAbout activating your Web site with data by using ASP or ASP.NET

Web sites based on ASP or ASP.NET can use desktop-based or server-based data sources — such as Microsoft Office Access 2003.

You can run either the Database Results Wizard or the Database Interface Wizard to create Web pages that display interactive views of desktop-based or server-based data by using ASP code or ASP.NET controls, depending on which technology is available on your Web server. Contact your Web server administrator or Internet service provider (ISP) for more information.

ShowAbout using the Database Results Wizard

By using the Database Results Wizard, you can connect to a database, create a query, apply filtering and sorting to the results, and display the data on a Web page that contains an optional search form for site visitors to use. You can also use the wizard to create a new Microsoft Access database, use a built-in sample database, connect to a database you created previously on your Web site, or connect to a database on another server that you have permission to access. You can connect to Microsoft Access, Microsoft SQL Server, and Oracle databases.

ShowAbout using the Database Interface Wizard

By using the Database Interface Wizard, you can create Web pages where you or your site visitors — depending on the settings you specify — can edit, delete, or add new records to a database by using a Web browser. You can connect to Microsoft Access, Microsoft SQL Server, and Oracle databases.

ShowServer requirements for working with data on Web sites based on ASP or ASP.NET

To use ASP, the following technologies are required on your Web server:

  • Microsoft Windows 2000, Microsoft Windows Server 2003, or Windows XP Professional
  • Microsoft Internet Information Services (IIS) 5.0 (or later)
  • Active Server Pages (ASP) with Microsoft ActiveX Data Objects (ADO)
  • FrontPage Server Extensions from Microsoft or SharePoint Team Services v1.0 from Microsoft

To use ASP.NET, the following technologies are required on your Web server:

  • Windows 2000, Windows XP Professional, or Microsoft Windows Server 2003
  • Microsoft Internet Information Services (IIS) 6.0 (or later)
  • ASP.NET

ShowAbout activating your Web site with the data-driven features of Windows SharePoint Services

Microsoft Windows SharePoint Services, which is built on the Microsoft .NET Framework, provides the component-based platform required for FrontPage data-driven functionality.

When you work with a site based on Windows SharePoint Services, you can access a wide range of data sources, including desktop-based and server-based databases, Extensible Markup Language (XML) files, Web services, and SharePoint lists. When you create a data-driven Web site, you select data sources from a data source catalog and use Data View Web Parts to present data. Data View Web Parts render data by using Extensible Stylesheet Language Transformation (XSLT).

ShowServer requirements for working with data on Windows SharePoint Services

To use Microsoft Windows SharePoint Services, the following technologies are required on your Web server:

  • Microsoft Windows Server 2003, Standard Edition, Enterprise Edition, Datacenter Edition, or Web Edition
  • Microsoft Internet Information Services (IIS) 6.0 in IIS 6.0 worker process isolation mode
  • ASP.NET