Identify the Database (RDS)

   

Before you create your .asp file, you must identify the database in the ODBC applet in Control Panel. In this example, you will use a Microsoft® Access database that is provided with Remote Data Service.

  1. At the computer running your Web server, open Control Panel.

  2. Double-click the ODBC icon, and then click System DSN.

    There are two types of data sources: User, which is available only to you, and System, which is available to anyone using the computer. Data sources for use with the Web server need to be System data sources.

  3. Click Add, choose Microsoft Access Driver, and then click Finish.

  4. In the Data Source Name box, type AdvWorks and click Select. Select the C:\Program Files\Common Files\System\MSADC\Samples\AdvWorks.mdb file, and click OK.

  5. Click OK to close the dialog boxes.

Next