Establishing a Database Connection

Running queries against a database requires that a DSN be created. After performing the steps described in “Creating ODBC Connections,” perform the following steps to connect to the database:

1          From the File menu, click New Connection.

2          Select the desired DSN in the Data Source Name drop-down list. The available data source names are architecture specific, for example, WinSQL32 will only display data sources that use a 32-bit ODBC driver.

3          Enter the appropriate user ID in the User ID field.

4          Enter the appropriate password in the Password field. The ODBC Data Source window should populated as follows:

5          Click OK to connect to the database.