Configure ODBC Connection window

The ODBC 32-bit drivers are supported only. The 32-bit driver is found in the following location:

C:\Windows\SysWOW64\odbcad32.exe.

Use this window to configure and test the supported ODBC connection strings using the following settings:

Data source name (DSN)

This setting provides a list of system and user data source names (DSN) configured on the local computer. If a new DSN is added, click Refresh to update the list.

The DSNs visible in this list are already present on the local computer. In order for any interaction with this database to work in a production environment, you need to add the same DSN connection on any machine running the Tungsten Transformation Toolkit - Server, as well as any workstation running a User Interactive Module.

Refresh

Use this button to update the list if a new DSN is added.

Login Information

This group has the following settings:

User Name: Enter the user name for the ODBC account.
Password: Enter the password for the above User Name.

Connection String

This string shows the connection to the database and is defined by the other settings in this window. If you have specified a password, it is fully encrypted and cannot be viewed. You can edit the connection string as needed. If you change any of the settings in the window, a new string is generated and overwrites any changes you made.

The following buttons are available at the bottom of this window:

Button	Description
Test Connection	Tests the connection string configuration to ensure that its settings are correct.
OK	Closes the window and saves your changes.
Cancel	Closes the window without saving your changes.
Help	Displays the help for the open window.