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.

Add a database data source

Add New Database Data Source Wizard

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

Allows you to select a User DSN and provide credentials:

• User Name

• Password

Allows you to select a System DSN and provide credentials:

• User Name

• Password

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

• User Name

• Password

• File Content

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

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

On 64-bit OS environments, select whether to open the administrator for the 32-bit or 64-bit data source.