Catalog an ADO.NET Connection

OpenESQL Assistant automatically catalogs any ODBC connection as an ODBC ADO.NET data provider if you have set your OpenESQL options to enable automatic cataloging. To use other ADO.NET data providers, you must catalog them manually using the ADO.NET Connection Editor. All cataloged data providers are listed on the Editor.

When you catalog a connection, the ADO.NET Connection Editor supplies default connection settings and values for the type of connection you catalog. You should edit the values to reflect the correct settings for your data source. Micro Focus provides templates for certain ADO.NET data providers as examples of what type of connection settings are required and what their values should be. See the section Example Connection Settings for specific examples.

You also have the option of encrypting your connection settings in the repository. You might want to do this if your connection settings include sensitive information such as a user ID and password used to access your application.

Visual COBOL runs as a 32-bit application. This means that when you access the ADO.NET Connection Editor from within Visual Studio, only connections usable by 32-bit applications are cataloged. In order to catalog connections usable by 64-bit applications, you must execute the ADO.NET Connection Editor from the Start Menu.