Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved What to do about error with Remote Procedure Calls

  1. Issue
0
Votes
Undo
  1. Becky Christensen
    Becky Christensen
  2. PowerBuilder
  3. Wednesday, 26 June 2024 18:51 PM UTC

I am upgrading from 12.6 Classic PowerBuilder to the latest 2022 R3 release.

Our application uses stored procedures via ODBC connection to the DB2 tables on the Mainframe.

The application verified the user log on,  so I know it can connect.

 
It fails then when calling a DB2 Stored Procedure.   Is there something that can be easily done to fix this with the upgrade?
 
Error is:  PowerBuilder application execution error (R0007)
 
                 Application terminated:
 
                  Error:   Database Interface does not support Remote Procedure Calls
Migrating PowerBuilder Embedded SQL from SQLAnywhe...
How to use WordCap / Upper / Lower of input values...
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 June 2024 19:27 PM UTC
  2. PowerBuilder
  3. # 1

Hi Becky;

  Have you tried using the new ODBC parameter "PBNewSPInvocation"?

FYI:  https://docs.appeon.com/pb2019/connecting_to_your_database/ch16s19.html

HTH

Regards .. Chris

Comment
Becky Christensen
  1. Becky Christensen
  2. Monday, 22 July 2024 18:41 PM UTC
Are you able to help me know how to do this as I have been using the free trial and I'm not sure where to do this from.
  1. Helpful
John Fauss
  1. John Fauss
  2. Monday, 22 July 2024 20:22 PM UTC
Hi, Becky - In regards to your reply to Chris' suggestion, please refer to the following online documentation:

https://docs.appeon.com/pb2022r3/connection_reference/ch01s01s104.html

You should take notice of the text following the sub-heading "Examples" in that Help topic.

Also: Please be aware that this is a Question/Answer forum, and not a Support Portal. The Community will be happy to help suggest an answer to a question (even multiple questions posted one at a time), but hands-on assistance is not what we do here - The questions in this forum are answered primarily by volunteers (Chris being unquestionably the exception). If after reviewing the documentation at the link above, you are unsure how to proceed and feel that you still need help, I suggest you consider purchasing a premium support ticket from Appeon: https://www.appeon.com/premium-support.html

There are also Appeon authorized consulting partners: https://www.appeon.com/consultants
  1. Helpful 1
Roland Smith
  1. Roland Smith
  2. Tuesday, 23 July 2024 14:15 PM UTC
It would be an additional option for sqlca.DBParm.
  1. Helpful 1
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.