Catalog a Connection using the ADO.NET Connection Editor

Guides you through the process of starting the ADO.NET Connection Editor from the OpenESQL Assistant, setting a save option, and cataloging the OESQLDemo connection.

Start the OpenESQL Assistant

  • From the Visual Studio main menu, click View > Micro Focus SQL Tools > OpenESQL Assistant.

Start the ADO.NET Connection Editor

  • In the OpenESQL Assistant, click Create New Query (ADO.NET Connection Editor).

Set to Save All Framework and Availability Combinations

By default, the platform target for your project is set to Any CPU. This means that it can use both 32- and 64-bit platforms and connections. In this tutorial, you catalog a 32-bit connection, but set the ADO.NET Connection editor to save all framework and connection combinations so that all are available regardless of the type of connection cataloged.

  • In the ADO.NET Connection Editor, click Settings Menu icon > Save > All framework/availability combinations, and then do one of the following:
    • If All framework/availability combinations is checked (Check mark), no further action is required.
    • If All framework/availability combinations is not checked, click it to check it.

Catalog the OESQLDemo Connection

  1. On the main window of the ADO.NET Connection Editor, click Add. This starts the Add an ADO.NET Connection wizard.
  2. Click Next.
  3. In the Data Source Name field, type OESQLDemo, which is the name of your connection, and then click Next.
  4. In the .NET Data Providers grid, select SqlClient Data Provider, then click Next.
  5. Modify the following fields on the Connection Settings grid, providing the specified values:
    Field Value
    Data Source (local)
    Initial Catalog OESQLDemo
    Integrated Security True
  6. Click Next to review your settings.
  7. Click Finish to add the new connection. This returns you to the main window.
  8. After the Data Source Names list refreshes, select the OESQLDemo entry.
  9. Click Test to ensure the connection works properly; then click OK to clear the message.

Close the ADO.NET Connection Editor

  • To close the ADO.NET Connection Editor, click the Close button button in the upper right corner of the main window. This returns you to the OpenESQL Assistant.

Refresh the list of connections in OpenESQL Assistant

To see the new connection in the OpenESQL Assistant, you must refresh the list:

  • On the OpenESQL Assistant tool bar, click Refresh list of data sources (Refresh).