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

OpenESQL database driver support

OpenESQL database driver support

Problem

Customer is moving from Net Express 5.1 native code to Visual COBOL 2.1 managed .NET code and they need to know what database driver should they use in order to access their SQL Server database.

Resolution:

In Visual COBOL you can create three types of applications each as 32-bit or 64-bit.

1. Native code, which includes int/.gnt and native Windows .EXE/.DLL formats or native Unix/Linuz executables and .so files.

2. Managed code .NET on Windows, .EXE/.DLL assemblies which run under the .NET Framework Common Language Runtime system.

3. Managed code JVM on Windows or Unix/Linux, generates Java .class files that will run under the Java Virtual Machine platform.

The type of database driver that you use depends upon the type of executable you are running.

Native Code = ODBC Drivers
Managed .NET = ADO Providers
Managed JVM = JDBC Drivers

These are not interchangable so if you are moving from Native code under Net Express to managed .NET code under Visual COBOL then you must change from using an ODBC driver to using an ADO Provder for the same database vendor. ADO Providers are available for SQL Server, Oracle and DB2.

 

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:
‎2013-04-19 08:49
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.