Previous Topic Next topic Print topic


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:
  • Tutorial: Create a SQL Server Database
  • Tutorial: Create and Configure an Eclipse Project
  • Tutorial: Set OpenESQL Assistant Configuration Options
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.
  1. From the ODBC Data Source Administrator, click the System DSN tab; then click Add.
  2. From the list of drivers, select the most recently installed version of SQL Server Native Client; then click Finish.
  3. In the Name field, type OESQLDemo. This is the name of the ODBC connection.
  4. 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.
  5. On the Authenticity dialog box, click Next to use Windows authentication.
  6. Change the default database to OESQLDemo; then click Next.
  7. Click Finish to save your changes.
  8. Click Test Data Source to ensure that the connection works properly.
  9. Click OK to clear the message.
  10. 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.
  • In the OpenESQL Assistant, click Refresh list of data sources.

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

Previous Topic Next topic Print topic