Problem:

OpenESQL assistant can connect to the data source, yet my application fails to connect with a SQLCODE of -19703.

Where are my ADO.NET "DSNs" under Net Express 5.0?

Resolution:

OpenESQL Assistant uses ODBC data sources, which have to be added/catalog'ed using the Microsoft ODBC Administrator.

For applications compiled with SQL(DBMAN=ADO) however these are not used -- you need to catalog the connection information using the Micro Focus Connection Editor. You can access this tool from within Visual Studio, under Tools -> Micro Focus COBOL Tools -> OpenESQL Assistant.

For Net Express 5.0 and later, you can also access the Connection Editor from the Start Menu.

There are step-by-step instructions for creating a "DSN" entry using the Connection Editor.

Look under Micro Focus Net Express with .NET -> Using Net Express with .NET -> User's Guide -> Using OpenESQL with ADO.NET, it links to the following section (OpenESQL Assistant) which walks through the process required.

Note -- within the Connection Editor, you need to hit the Save button prior to testing the connection, or exiting the Connection Editor.

Under Net Express 5.0, a different repository is used for these ADO.NET "DSNs" -- the Microsoft .NET Framework machine.config file. The connection editor is still available, and we additionally provide a migration utility from the Start menu, for cataloging your existing connections from Net Express 4.0 with .NET.