Tutorial: Catalog a Connection

Before you can connect to the SQL Server database you created earlier, you must catalog it using the ODBC Data Source Administrator (32-bit).

Requirements

Before attempting this tutorial, you must complete the following tutorials in the order listed:

Phase 1: Start the ODBC Data Source Administrator (32-bit)

Click Start > All Programs > Micro Focus Enterprise Developer > Enterprise Developer for Eclipse > Data Tools > Data Connections > ODBC Data Source Administrator (32-bit).

Note: On Windows 8, you can also go to the Start screen and click the ODBC Data Source Administrator (32-bit) tile.

Phase 2: Catalog the OESQLDemo Connection

In this phase, we catalog a 32-bit connection to our SQL Server database.

From the ODBC Data Source Administrator, click the System DSN tab; then click Add.
From the list of drivers, select the most recently installed version of SQL Server Native Client; then click Finish.
In the Name field, type OESQLDemo. This is the name of the ODBC connection.
From the drop-down list, select a SQL Server, or type the name of a server such as (local) or (localdb\v11.0), depending on what SQL Server product you have installed; then click Next.
On the Authenticity dialog box, click Next to use Windows authentication.
Change the default database to OESQLDemo; then click Next.
Click Finish to save your changes.
Click Test Data Source to ensure that the connection works properly.
Click OK to clear the message.
Click OK twice to exit the ODBC Data Source Administrator.

Phase 3: Refresh the Database Connection

For OpenESQL Assistant to recognize the connection you have cataloged, you must refresh the connection list in the OpenESQL Assistant.

This completes the tutorial. Next, please complete Tutorial: Build and Test a Query.