Skip to main content

Hello,

I'm working on a Visual COBOL application that connects to a relational database via ODBC. I want to know:

  • What ODBC driver properties or attributes does Visual COBOL expect for proper functioning?

  • Are there specific cursor types, transaction settings, or character set requirements?

  • Any known limitations or recommended configurations for ODBC drivers with Visual COBOL?.

Any guidance or references from Micro Focus / Rocket documentation would be greatly appreciated.

Thank you!



------------------------------
Divya Koduri
Engineer
Unisys Corporation
Banglore IN
------------------------------

Hello,

I'm working on a Visual COBOL application that connects to a relational database via ODBC. I want to know:

  • What ODBC driver properties or attributes does Visual COBOL expect for proper functioning?

  • Are there specific cursor types, transaction settings, or character set requirements?

  • Any known limitations or recommended configurations for ODBC drivers with Visual COBOL?.

Any guidance or references from Micro Focus / Rocket documentation would be greatly appreciated.

Thank you!



------------------------------
Divya Koduri
Engineer
Unisys Corporation
Banglore IN
------------------------------

Hi Divya,

What database are you trying to access?

OpenESQL was developed to be agnostic in that most ODBC 3.0-compliant drivers will work correctly, although not all drivers have been explicitly tested.
The documentation for Database Access, which includes OpenESQL for ODBC, ADO.NET and JDBC, can be found here: 

You can set properties, attributes, cursor types and transaction settings by using various EXEC SQL statements within your application.



------------------------------
Chris Glazier
Principal Technical Support Specialist
Rocket Forum Shared Account
------------------------------

Hi Divya,

What database are you trying to access?

OpenESQL was developed to be agnostic in that most ODBC 3.0-compliant drivers will work correctly, although not all drivers have been explicitly tested.
The documentation for Database Access, which includes OpenESQL for ODBC, ADO.NET and JDBC, can be found here: 

You can set properties, attributes, cursor types and transaction settings by using various EXEC SQL statements within your application.



------------------------------
Chris Glazier
Principal Technical Support Specialist
Rocket Forum Shared Account
------------------------------

Hi Chris,

Thank you for the explanation.

I wasn't able to access the documentation link you shared. Could you please point me to a publicly accessible link or provide the key ODBC driver properties/attributes that are typically required for Visual COBOL to work smoothly?



------------------------------
Divya Koduri
Engineer
Unisys Corporation
Banglore IN
------------------------------

Hi Chris,

Thank you for the explanation.

I wasn't able to access the documentation link you shared. Could you please point me to a publicly accessible link or provide the key ODBC driver properties/attributes that are typically required for Visual COBOL to work smoothly?



------------------------------
Divya Koduri
Engineer
Unisys Corporation
Banglore IN
------------------------------

Hi Divya,

Sorry about that. Please try this link instead:

Database Access



------------------------------
Chris Glazier
Principal Technical Support Specialist
Rocket Forum Shared Account
------------------------------