FP97: How to Make a Web Page Display Data from a Database

• Microsoft FrontPage 97 for Windows with Bonus Pack

SUMMARY

FrontPage 97 has a built-in Internet Database Connector Wizard which, when used with the Database Results Page template, can create database queries that will function with the Microsoft Personal Web Server, Microsoft Peer Web Services, or Microsoft Internet Information Server. This article describes how to get started using the Internet Database Connector and where to get more information about it.

NOTE: FrontPage 97 will not record Structured Query Language (SQL) or show you the table structure of the database you are querying. The Internet Database Connector Wizard will write the proper file for you, but you will need to know the SQL and the table structure needed to reach your data.

MORE INFORMATION

To start using the Internet Database Connector, use the following steps:

1. Make sure you have all of the following components:

       - Microsoft Personal Web Server, Microsoft Peer Web Services, or
         Microsoft Internet Information Server.
   

       - An ODBC Driver for your database management system.
   

       - A database.
   

2. Create a system data source name using your ODBC Driver. For additional information, please see the following article in the Microsoft Knowledge Base:

         ARTICLE-ID: Q161172
         TITLE     : ACC97: How to Use IDC Files to Query a Secure MS Access
                     Database
   
   

3. Do the following:

       a. On the File menu, click New.
   

       b. In the Template Or Wizard list, select the Database Results template
          and then click OK.
   

          -or-
   

          On the Edit menu, point to Database, and then click the command you
          want.
   

4. On the File menu, click New.

5. In the Template Or Wizard list, select the Database Connector Wizard, and then click OK.

6. In the ODBC Data Source box, type the name of your data source. Type a user name and password, if desired. In the Query Results Template box, type the file name of the file you created in step 3. Click Next.

7. Enter the SQL statement you want, and then click next.

8. In the Default Parameters box, specify the parameters and values you want, and then click Finish.

9. In the Current Web dialog box, in the Save As box, type they file name you want, using an .idc file extension. Select a folder in your Web where executable files can be stored. Click OK.

For more information about Internet Database Connector files, see the Internet Information Server "Installation and Administration Guide" at the following Microsoft World Wide Web site:

   http://www.microsoft.com/iis/usingiis/resources/docsdefault.htm

   http://support.microsoft.com/support/frontpage/content/idc/default.asp

   http://www.microsoft.com/