Creating the .idc File

The .idc file contains the information to send queries to a database. An .idc file must contain the following information:

• The ODBC data source. For example, the following statement identifies the data source called Web SQL:

  Datasource: Web SQL
  

• Any user name (valid logon name) required to access the data source. For example, the following statement logs on to the sa account on Microsoft SQL Server:

  Username:  sa
  

• The name of the HTML extension file that will contain the formatted data returned to the browser:

  Template: sample.htx
  

• The SQL statement to execute. For example, the following statement returns all the author last names and year-to-date sales in units from the "pubs" sample database in SQL Server for authors whose books have year-to-date sales of more than 5000:

  SQLStatement:
  +SELECT au_lname, ytd_sales 
  + from pubs.dbo.titleview
  + where ytd_sales>5000