Connect to an ODBC source: Example

The procedure provides an example of how to connect to an ODBC source (using Windows 7) when connecting individual fields to a specific database table.

Use the following steps as inspiration to connect to an ODBC source on Windows 7:

  1. Click Start > Control Panel.
  2. Open Administrative Tools and double-click Data Sources (ODBC).
  3. On the System DSN tab of the dialog, click Add.
  4. Select SQL Server, and then click Finish.
  5. Type an appropriate name and description (if desired) for the data source in the Name and Description boxes respectively. Make a note of the name as you will need it later.
  6. In the Server box, select the appropriate server from the dropdown list, or type in the server name if it is not in the list. Click Next.
  7. Select With Windows NT autentication using the network login ID and click Next.
  8. Select Change the default database to and select the name, specified in step 5, from the dropdown list, and click Next.
  9. Select Perform translation for character data and click Finish.
  10. Click Test Data Source to test the connection. You should receive the message, "TESTS COMPLETED SUCCESSFULLY!"
  11. Click OK twice to return to the System DSN tab of the dialog, and click OK once more to close the dialog.