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 reply
    1
  • Answers answer
    1
  • Subscribers subscribers
    11
  • Views views
    225
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Calling a sql server store prodcedure from AcuCOBOL

Bart Pelgrims

Hi,

I created a stored procedure in sql server, and trying to call it from AcuCOBOL but getting this error:

Could not find stored procedure 'sp_test'    42000

It does exist in sql server, with all rights granted.

Calling code looks like this:

EXEC SQL

  DECLARE CURSOR-SP CURSOR FOR

    :ret-code = exec sp_test

END-EXEC

It's a bit confusing as 42000 means acuodbc driver expected, but I'm using the acusql driver, not ODBC

  • Suggested Answer

    0  

    Good morning, Mr.  .

    Have you searched this Community for other situations like yours?

    For example, there's an article here that may help you.

    It's a bit aged, but it gives useful information.

    If it does not help, please contact Customer Support, providing information about the version of AcuSQL you're using.

    A local engineer will help you with the investigation of the error.

    Claudio Contardi

    Lead Technical Support Specialist
    Rocket Software, Italia
    RocketSoftware.com
    linkedin.com/rocket-software

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.