Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

How to convert .NET COBOL Application from SQL ODBC to use SQL ADO technology?

How to convert .NET COBOL Application from SQL ODBC to use SQL ADO technology?

Problem:

Is it possible to convert a .NET COBOL Application from SQL ODBC to use SQL ADO technology?

If planning to migrate or creating a COBOL application using .NET Framework managed code, it is recommended to consider using SQL ADO technology rather than ODBC Technology.
ADO is designed to be used with managed code .NET Framework applications, giving potential easier integration and stability.

Resolution:

In terms of COBOL code changes,if you plan to make use of the additional ADO features change any SQL(DBMAN=ODBC) directives to SQL(DBMAN=ADO)

Additionally, configure the ADO Database Connection (similar concept to configuring an ODBC connection).

Do this via the ADO.NET Connection Editor tool that ships with Visual COBOL/Enterprise Developer (Accessible via the Windows Start Menu group for the Visual COBOL or Enterprise Developer Program Group > Data Tools > Data Connections).

Once the ADO connection is set up and SQL DBMAN directive updated, then recompile the application to start using ADO Technology.

For more information regarding how ADO works, try the ADO Sample Solution that ships with Visual COBOL/Enterprise Developer, usually located in path: Enterprise Developer: %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\sql\ado.net Visual COBOL: %PUBLIC%\Documents\Micro Focus\Visual COBOL\Samples\sql\ado.net

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2016-04-07 10:39
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.