Rocket® Enterprise Test Server (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
ADO.NET Connection Editor
The ADO.NET Connection Editor enables you to define and manage connection configurations used by the OpenESQL Managed Runtime when connecting a COBOL program to an ADO.NET or an ODBC data provider.
Connection information is stored in a standard .NET Framework repository, machine.config, which enables mixed language applications to share connection strings. The repository is accessible to all users of the machine on which it is installed.
The OpenESQL Managed Runtime supports any ADO.NET provider that supports the DbProviderFactory API.
Note:
- We recommend that you use ADO.NET data providers when possible; however, the ADO.NET connection editor catalogs ODBC connections that you can use if necessary.
- When you run the ADO.NET Connection Editor under operating systems that have User Access Control enabled, you must run it as an administrator if you are adding, deleting, or updating connections for System type connections. However, when updating User type connections, you do not need this elevated authority. See the To start the ADO.NET Connection Editor as an administrator and To start the ADO.NET Connection Editor as a user topics for more information.
- The ADO.NET Connection Editor works in combinations of 32- or 64-bit and framework 2.0, 3.0, 3.5 or framework 4.0, 4.5, 4.6, 4.7 and 4.8. Whichever mode you work in, you must have the 32-bit framework 4.0, 4.5, 4.6, 4.7, or 4.8 version of the provider that you want to work with your connection.