Overview: How does IIS/ODBC/IDC/HTX work?
A. Web browser makes a request to IIS for the IDC file.
B. IIS reads the IDC file, which contains the SQL query and other information such as the data source and possibly a user name and password.
C. The Internet Database Component of IIS opens the Microsoft Access database (using the Microsoft Access Desktop ODBC Driver and the IDC file connection information) and runs the query in the IDC file to access the data.
D. IIS dynamically merges the results of the query in the IDC file with the HTX file into one 'pure' HTML file.
E. IIS sends the HTML file back to the Web browser for display as a Web page.
Slide 17