Configuring ODBC Connections for SQL

The steps for configuring ODBC connections for SQL or Oracle are similar.

  1. Click Control Panel > Administrative Tools > Data Sources (ODBC).
  2. On the System DSN tab, click Add.

    The Create New Data Source dialog box is displayed.

  3. Select SQL Server and click Finish.

    The Create a New Data Source to SQL Server dialog box is displayed.

  4. In the Name and Description fields, type an appropriate name and description for the data source, for example, mmsdata1.
  5. From the Server list, select (local) or the appropriate server name. Click Next.
  6. Click the With Windows NT authentication using the network login ID option, and then click Next.
  7. Click the Change the default database to option and select the corresponding database name from the list, for example, mmsdata1, and then,click Next.
  8. Click Finish.

    The ODBC Microsoft SQL Server Setup dialog box is displayed.

  9. To ensure that the connection is working, click Test Data Source.

    • If the test fails, go back and check the settings.

    • If the test is successful, click OK. You are returned to the ODBC Data Source Administrator.

  10. Click OK.