You need no special configuration in Internet Service Manager to implement database connectivity by using Internet Database Connector. The Httpodbc.dll module supplies database connectivity. Httpodbc.dll is automatically loaded when Internet Information Server starts. To install Httpodbc.dll, you select the ODBC option during Internet Information Server setup.
Prior to using the database, you must create a system Data Source Name(DSN). The Data Source Name is a logical name used by Windows NT Open Database Connectivity (ODBC) to refer to the driver and any other information required to access the data, such as the actual server name or location of the database. You specify the Data Source Name in Internet Database Connector files to tell Internet Information Server where to access the data. For more information about using the DSN in .idc files, see "Accessing the Database," later in this section.
The simplest method to create a DSN is to use the sample pages provided with Internet Information Server. To access the sample pages, first make sure your World Wide Web (WWW) service is running. Then use Internet Explorer to access your own IIS server. For example, type http://orderdesk in the location box. The Database page contains a hyperlink to create the system data source. The manual method for creating a data source follows.
1. Double-click ODBC in Control Panel.
The Data Sources dialog box appears. Other data sources appear in the list if you previously installed other ODBC drivers.
2. Click System DSN. In the System Data Sources dialog box, click Add.
Important: Be sure to click System DSN. The Internet Database Connector works only with system DSNs.
3. In the Add Data Source dialog box, select an ODBC driver in the list box, then click OK.
A dialog box specific to your driver appears. To install third-party ODBC drivers, see your third-party database documentation.
4. In the dialog box specific to your driver, enter the name of the data source and any other required information, then click OK.
The System Data Sources dialog box appears again, but now it has the name of the data source displayed.
If you do not know what to enter in the dialog box specific to your driver, accept the defaults. To find out the details, click Help and find the section that describes your network.
5. To close the System Data Sources dialog box, click Close. To close the Data Sources dialog box, click Close again.
6. To complete the ODBC and DSN setup, click OK.