1.4.2. Configure SQL Server for Tracker

  1. Select the System DSN tab.

  2. Click Add. 

  1. Choose SQL Native Client.

  1. Click Finish.

  2. Enter the following in the Create a New Data Source to SQL Server dialog box.

Name

TRK61

Description

Tracker Tutorial

Server

(local) or a SQL database that has been assigned to this project, e.g. computer name\CIMPLICITY.

  1. Click Next.

  2. Do the following for the Login:

A

Check With SQL Server Authentication using a login ID and password entered by the user.

B

Check Connect to SQL Server to obtain default settings for the additional configuration options.

C

Enter the Login ID and Password required by your SQL database.

  1. Click Next to move through the following dialog boxes until the ODBC Microsoft SQL Server Setup dialog box displays.

  2. Test the data source to verify the connection to the database.

  1. Click OK.

  2. Click OK to close the ODBC Data Source Administrator dialog box.

Result: The ODBC Data Administrator closes and the TrackerCfg_UI displays two folders.

You will work in both during this tutorial.

More information