Creating an ODBC Connection with the ODBC Data Source Administrator

  1. In Windows 98 or Windows NT, go to Start, Settings, Control Panel and double-click the Data Sources (ODBC) icon. In Windows 2000 or Windows XP, go to Start, Control Panel, Administrative Tools and double-click the Data Sources (ODBC) icon. This opens the ODBC Data Source Administrator.
  2. Activate the System DSN tab and click the Add button.
  3. Select the corresponding driver for your database from the list of drivers, and then click Finish .

    Access: Microsoft Access Driver (*.mdb)

    Microsoft SQL Server: SQL Server.

  4. Enter the name you want to use to refer to this data source. Specify the database and other settings depending on the chosen driver. Different settings are required for different drivers.
  5. Click the OK button to return to the System DSN tab, and then click OK again to exit the ODBC Data Source Administrator.