Knowledge Base

Commenting an Internet Database Connector (IDC) File

Article ID: 150809

Article Last Modified on 6/23/2005


APPLIES TO


This article was previously published under Q150809
We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

SUMMARY

Internet Database Connector (IDC) files are used in the Internet Information Server (IIS) to specify an ODBC data source, username, template, and SQL statements to exchange data with a database.

To place comments in an IDC file, begin a line with either the pound sign (#) or semi-colon (;).

MORE INFORMATION

Here is an example IDC file with comments:
; this is a comment
Datasource: Web SQL
Username: sa
Password:
Template: ctguestb.htx
SQLStatement:
+CREATE TABLE "Guests" (
+"FirstName" varchar(40),
+"LastName" varchar(40),
+"Email" varchar(40),
+"Homepage" varchar(80),
+"Comment" text,
+"WebUse" varchar(40)
+)
# This is also a comment
				

Additional query words: prodiis

Keywords: kbhowto kbnetwork KB150809