1. 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)
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 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 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 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.
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.