Import a database

About importing a database into your web site

• A database imported into a server-based web site can be used without the involvement of a server administrator or Internet service provider (ISP). A System DSN (system DSN: A system data source name is specific to a local computer. The system or any user with privileges can use a data source that is set up with a system DSN.), on the other hand, requires access to the resources and file system of the web server.
• If you have a disk-based web site that you want to publish to a server-based web site, the database on the disk-based web site, and the database connection, will transfer to the server-based web site during publishing. You won't need to create a new database connection on the destination web site or involve a server administrator or your ISP.
• If the database you're importing is a Microsoft Access database, you will be asked to create a database connection and to store the file in the Fpdb folder. Permissions are set for the Fpdb folder specifying that the folder can't be viewed in a Web browser. You can protect the privacy of your database by moving it into the Fpdb folder.
• Also with an Access database, you can enter data into the database through a web interface. The data will then be available to other Microsoft Office applications that can connect to Access databases.

How to import a database, create a connection, and display data

1. On the File menu, click Import, click Add File, and then select the database you want to import.
2. To create a new database connection, type a name for the connection in the Name box.
3. To display information from the database on a page, start the Database Results Wizard (Database Results Wizard: A FrontPage wizard that guides you through creating a region on a page that displays information obtained from the records of a database. You can use an existing database to accomplish this or let the wizard create one for you.) by clicking the Insert menu, pointing to Database, and then clicking Results). Follow the steps in the wizard.

   Note   Depending on its size, it might take several minutes to import your database.

Before you view the database results

To view the data once you set up the connection and complete the steps in he Database Results Wizard (Database Results Wizard: A FrontPage wizard that guides you through creating a region on a page that displays information obtained from the records of a database. You can use an existing database to accomplish this or let the wizard create one for you.), your web site must be hosted or published on a web server configured with:

• Active Server Pages (ASP) (ASP: Active Server Pages. A server-side ing technology used to create dynamic interactive web applications. An ASP file is an HTML page containing s processed by a Web server before being sent to a browser. ) 
• ActiveX Data Objects (ADO) (ActiveX Data Objects (ADO): A data access interface that communicates with OLE DB-compliant data sources to connect to, retrieve, manipulate, and update data.)
• Microsoft FrontPage 2000 Server Extensions (FrontPage Server Extensions: A set of programs and s that support authoring in FrontPage and extend the functionality of a Web server. ) (or later) or SharePoint Team Services

Ask your Internet service provider (ISP) or web server administrator whether your web server is configured with these options.