FrontPage Database Connector

The three basic files needed to get started are shown in the next sections. This sample provides instructions in creating a query form that can be used to retrieve information from your Image database using most browsers and Microsoft's IIS (Internet Information Server) and FrontPage.

Download this sample: FTP • HTTP

The HTX file

1. Create the results (.htx) page.
2. The field (Image Item) names appear in place of the <%name%> sequences in the result form. 
   
   
   
3. Use the saved form when creating the (.idc) file.

---

The IDC file

1. Create an Internet Database Connector file using the wizard.
   
   
   
2. Reference the DataSource that is configured on the server as a System DSN.
3. Enter the SQL statement for the query with a reference to the query form field that will be substituted in when the query is executed.
   
   
   
4. Assign a default value if needed.
   
   

---

The HTM file

1. Create a page with a simple query form.
   
   
   
2. Set 'Internet Database Connector' as the Form Handler type.
   
   
   
3. Enter the name of an Internet Database Connector File:
   
   
   
4. Set the name and properties of the query form text box.
   
   

---

How this sample appears: