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
Start the ODBC Data Source Administrator (32-bit)
This tool is available from your Start menu or Start > Apps page, depending on your Windows operating system.
Start > Apps Page
Go to your Start > Apps page, and click the ODBC Data Source Administrator (32-bit) tile that appears under Micro Focus Visual COBOL.
Start Menu
Click Start > All Programs > or All Apps > Micro Focus Enterprise Developer > Visual COBOL for Eclipse > Data Tools > Data Connections > ODBC Data Source Administrator (32-bit).
Catalog the OESQLDemo Connection
Using the ODBC Data Source Administrator, you catalog a 32-bit connection to your 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.
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.