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

Resolved RPCFunc, Can not get parameters of procedure

  1. How-to
0
Votes
Undo
  1. Aart Onkenhout
    Aart Onkenhout
  2. PowerBuilder
  3. Thursday, 26 October 2023 16:22 PM UTC

Hi,

We're working with sql server 2019 and the latest msoledb driver (from https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16). When calling a procedure that has output parameters we get the error 'Can not get parameters of procedure '. I saw a similar issue (https://community.appeon.com/index.php/qna/q-a/rpc-error-can-not-get-parameters-of-procedure) where setting execute rights on the procedure solved the problem. In our case, the user already has execute rights on the procedure. Only making the user sysadmin makes the error go away. Is this normal behaviour or are we missing something (hopefully not as we don't want to make every user sysadmin). Our DBParm is like "PROVIDER='MSOLEDBSQL19',DATASOURCE='FXSQL-PO-C1213',PROVIDERSTRING='Database=FlexDatabase_Local_Aart',BinTxtBlob=1".

Any suggestion is welcomed.

Regards,

Aart

XMLParseString is not working as expected.
Customizing Highlight Color for Selected Rows in a...
Accepted Answer
Aart Onkenhout
Aart Onkenhout Accepted Answer Pending Moderation
  1. Tuesday, 31 October 2023 06:59 AM UTC
  2. PowerBuilder
  3. # Permalink

Issue was solved by adding 'dbo.' in my rpcfunc alias (so ALIAS FOR 'dbo.sp_MyPorc' in stead of  ALIAS FOR 'sp_MyProoc').

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 31 October 2023 11:26 AM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
Responses (5)
Aart Onkenhout
Aart Onkenhout Accepted Answer Pending Moderation
  1. Sunday, 29 October 2023 15:48 PM UTC
  2. PowerBuilder
  3. # 1

Hi Miguel,

Thank you for the suggestion. Unfortunately, it doesn't help (documentation says it doesn't work with rpc which is what we're using).

Regards, Aart

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Sunday, 29 October 2023 22:23 PM UTC
Sorry to hear that. Let's see if Appeon solves the ticket

regards
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Sunday, 29 October 2023 15:13 PM UTC
  2. PowerBuilder
  3. # 2

Hi,

Try using this dbparm https://docs.appeon.com/pb2022/connection_reference/ch01s01s111.html . I'm not sure if it'll work for anything else than ODBC, but it seems to say it'll work for OLEDB ?

regards/

Comment
There are no comments made yet.
Aart Onkenhout
Aart Onkenhout Accepted Answer Pending Moderation
  1. Sunday, 29 October 2023 09:52 AM UTC
  2. PowerBuilder
  3. # 3

Hi Armeen,

The answer to both questions is yes. In the meantime I reported it as a bug (https://www.appeon.com/standardsupport/search/view?id=11087, private), as I think there is a difference between how the OLE DB driver handles this kind of rpcfuncs  and the MS OLE DB Driver does.

Regards,

Aart

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 30 October 2023 13:48 PM UTC
I see. OK, let's see what our support team figures out.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Saturday, 28 October 2023 15:42 PM UTC
  2. PowerBuilder
  3. # 4

Are you using version 19.3.2 of the Microsoft OLE DB Driver?

If yes, are you using R2 version of PB 2022?  The latest version of driver requires R2: https://docs.appeon.com/pb/whats_new/ch01s01s01.html

Comment
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.