Select Data Source Name Dialog Box

Relevant for: API testing only

This dialog helps you build a connection string for an ODBC data source.

To access

Do one of the following:

From the Database wizard:

  1. Choose Database in the Data pane to open the wizard.
  2. Select ODBC as a connection type.
  3. Click on the Build Connection String button adjacent to the Connection list drop down list.

From the Properties pane:

  1. Add a Database Open Connection activity to the canvas.
  2. Click the Input/Checkpoints tab in the Properties pane and click the browse button in the Connection string property row.
  3. In the Connection Builder Dialog Box, select ODBC as a connection type.
  4. Click on the Build Connection String button adjacent to the Connection list drop down.
Relevant tasks

Add a database data source

See also

Add New Database Data Source Wizard

User interface elements depend on the type of DSN selected:

UI Element

Description

Reload DSN List. Reloads the items that will appear in the drop down list.

User DSN

Allows you to select a User DSN and provide credentials:

  • User Name

  • Password

System DSN

Allows you to select a System DSN and provide credentials:

  • User Name

  • Password

File DSN

Allows you to provide the following information for the File DSN or select a file with the required settings.

  • User Name

  • Password

  • File Content

Test Connection

Sends the current DSN information to the database server to check its validity.

Manage ODBC Data Sources

Opens the Microsoft ODBC Data Source Administrator dialog box. This dialog box lets you add, edit or delete data sources at the Windows level.

Tip: After you create or modify a data source on the Windows level, click the Reload DSN List button to refresh the DSN list.