• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Mismatch between retrieve columns and fetch columns

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

Resolved Mismatch between retrieve columns and fetch columns

  1. Issue
0
Votes
Undo
  1. Prasad Neelapala
    Prasad Neelapala
  2. PowerBuilder
  3. Wednesday, 8 June 2022 07:43 AM UTC 
*Phenomenon:
connected to mssql in powerbuilder and tried to run the exe

*Reproduce Steps:
Run the application using MSSQL
Remarks:

Please let us know how to resolve the issue.
// Profile PRC SQL
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = <********>
SQLCA.ServerName = "***************"
SQLCA.LogId = "prcmsdev"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Provider='SQLNCLI11',Database='PrcDb'"

Mismatch between retrieve columns and fetch columns when connected to MSSQL
Attachments (1)
error.png error.png
  1. PowerBuilder Runtime
Digrama de Gant
Proxy settings for OauthCLient.AccessToken and Oau...
Responses (4)
Prasad Neelapala
Prasad Neelapala Accepted Answer Pending Moderation
  1. Monday, 13 June 2022 08:14 AM UTC
  2. PowerBuilder
  3. # 1

We are upgrading the existing application to 2019 R3 version and after connecting to MSSQL we are trying to run the exe from PB workspace and after that we are able to login to MSSQL in the exe and i am trying to run the menus in the application likes  rates and reports when i am trying to run some menus i am getting this error 

let me know if you need further info

Comment
There are no comments made yet.
Prasad Neelapala
Prasad Neelapala Accepted Answer Pending Moderation
  1. Wednesday, 8 June 2022 10:57 AM UTC
  2. PowerBuilder
  3. # 2

I am new to powerbuilder someone please connect with me and help me with this or let me know steps to resolve this

 

Comment
There are no comments made yet.
Prasad Neelapala
Prasad Neelapala Accepted Answer Pending Moderation
  1. Wednesday, 8 June 2022 10:56 AM UTC
  2. PowerBuilder
  3. # 3

We are upgrading the existing application to 2019 R3 version and after connecting to MSSQL we are trying to run the exe from PB workspace and after that we are able to login to MSSQL in the exe and i am trying to run the menus in the application likes  rates and reports when i am trying to run some menus i am getting this error 

let me know if you need further info

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Wednesday, 8 June 2022 08:25 AM UTC
  2. PowerBuilder
  3. # 4

Hi.

You don't give enough information. When the error occurs, what are you trying to do? Do you execute a procedure? Fetch a cursor? Retrieve a datawindow? You should provide more details.

Andreas.

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.