Running SQL Queries from an IDC File on IIS

  • Article

To run the IDC query, embed a link to the .idc file in an HTML file.

For example, the following HTML statement sends a request for the file dbsamp.idc to the Web server.

<A HREF="http://server_name/scripts/dbsamp.idc">Click here to run query</A>

When the Web server receives the request, the server uses the Web site's application mapping properties to associate the file name extension (.idc) with the program used to process IDC files (Httpodbc.dll). The Web server calls Internet Database Connector (Httpodbc.dll), which connects to the specified data source and sends the SQL statements to the database. When the SQL statements have been run, Internet Database Connector merges the returned data into the .htx file. Internet Database Connector sends the merged document back to the Web server, which returns it to the browser.

By default, the file name extension .idc is mapped to the Internet Database Connector application when you install Internet Information Services. You can add, remove, or edit application mappings as needed.