• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Please advise on the errors while creating datawindow by using stored procedure

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

Resolved Please advise on the errors while creating datawindow by using stored procedure

  1. How-to
0
Votes
Undo
  1. Minogue Susan
    Minogue Susan
  2. PowerBuilder
  3. Thursday, 16 May 2019 09:55 AM UTC

Hi,

I am trying to create a data window in PowerBuilder 2017 R3. I am following the below steps.

New->data window->rich text->stored procedure

After selecting the stored procedure then I am getting the below error as shown in screenshot though we specified correct datatypes. If I am trying to give manually by clicking manual result set options then I am getting error as invalid column name. Why this errors if we are giving correct data types as per backend(stored procedure). Please advise.

Convert numeric to string .net webservice fails
How to suppress ODBC login window after incorrect ...
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 May 2019 14:24 PM UTC
  2. PowerBuilder
  3. # 1

Hi Sadananda;

   Can you tell us ...

1) The DBMS & version that you are using

2) DB Client that you are using to connect to your DBMS

3) PB IDE's DB Profile settings you have used.

4) Show us the SP syntax declarations.

Thanks ... Chris

Comment
Minogue Susan
  1. Minogue Susan
  2. Thursday, 16 May 2019 16:20 PM UTC
Hi Chris,

Version:Microsoft SQL Server 2014 (SP3-CU1) (KB4470220) - 12.0.6205.1 (X64) Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 (Build 9600:(Hypervisor)(SQL server management studio)

DB profile settings: ODB ODBC (we used)

Database connection syntax in DB profile ODB ODBC:// Profile CIRS_DEV

SQLCA.DBMS = "ODBC"

SQLCA.AutoCommit = False

SQLCA.DBParm = "ConnectString='DSN=CIRS_DEV1;UID=tbsivani;PWD='"

Stored procedure: exec Stored_proc name 'date' in SQL

eg: exec asp_getl_test '01/06/2019'(Date is the only parameter we are passing while executing and data type is datetime). Please advise



Thanks









  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 16 May 2019 10:29 AM UTC
  2. PowerBuilder
  3. # 2

Could it have something to do with having to set the dbparm for PBNewSPInvocation to 'Yes' ?

regards,

MiguelL

Comment
Minogue Susan
  1. Minogue Susan
  2. Thursday, 16 May 2019 11:25 AM UTC
Hi Miguel,

Thanks. We have tried but still the same error
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 16 May 2019 13:25 PM UTC
Have you tried / Can you try with the SNCLI native driver? I've had problems with odbc and other databases.

Maybe ADO or OLEDB driver?

  1. Helpful
There are no comments made yet.
DIPANJAN DUTTA
DIPANJAN DUTTA Accepted Answer Pending Moderation
  1. Thursday, 16 May 2019 10:10 AM UTC
  2. PowerBuilder
  3. # 3

Hi Sadananda,

Please check your procedure input argument datatype and DW Retrieval argument datatype once again

Comment
Minogue Susan
  1. Minogue Susan
  2. Thursday, 16 May 2019 10:14 AM UTC
Hi Dipanjan,

Thanks for reply. We have checked the argument datatype and retrieval too but still it is not working.
  1. Helpful
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.