Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Suggested Answer
  • Replies replies
    5
  • Answers answer
    1
  • Subscribers subscribers
    15
  • Views views
    286
  • Users 0 members are here
Related
Options

DB reconnect issues to SQL2012 using VisualCOBOL8.

Aldous Carlos

Hi Gents,

Any experiences using msodbc and unixODBC on RHEL  with VisualCOBOL8 on RHEL to connect SQL2012? 
 

We are currently experiencing DB reconnect issues to our SQL2012 with our COBOL 8 programs on RHEL8 , using using msodbcsql18 and unixODBC2.3.11 .

It was working before with the same COBOL source codes on RHEL6, COBOL5express, using msodbcsql11 and unixODBC2.3.0.


Thanks

Parents
  • 0  

    Hi Aldous Carlos,

    Thanks for sharing some details about your new environment. It sounds like you were using Server Express 5.1 previously, and are now moving to Visual COBOL 8.

    Can you let us know the exact error message you receive when you try to connect?

    Also, have you tried using the isql utility (interactive SQL prompt, which I believe is provided with UnixODBC) to confirm the UnixODBC configuration is set up correctly on the new machine?

  • 0   in reply to   

    Hi Again,

     

    I've just noticed that you are connecting to Microsoft SQL Server 2012. Please note that this version of SQL Server is not supported in Visual COBOL 8.0 . Please see this page in the Visual COBOL documentation for information, by Visual COBOL product version, on supported Relational Database Management Systems and versions.

  • 0 in reply to   

    We tried to connect to a SQLServer2019  to see if the db reconnect improves, but still had the same result.

    Thanks.

Reply Children
No Data

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.