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

Resolved Retrieve data in datawindow

  1. How-to
0
Votes
Undo
  1. Orlando Algentera
    Orlando Algentera
  2. PowerBuilder
  3. Wednesday, 8 August 2018 18:52 PM UTC

How to retrieve datawindow in PowerServer Web?

Below are my configuration:

**Open event script of my window 

if AppeonGetClientType() = 'PB' then
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=PB Demo DB V2017R2 Unicode;UID=dba;PWD=sql'"
elseif AppeonGetClientType() = 'WEB' then
SQLCA.DBMS = "OLE-MSS"
SQLCA.DBParm = "CacheName='LPPS'"
else //'MOBILE'
end if

connect using sqlca;

if sqlca.sqlcode <> 0 then
messagebox('test',sqlca.sqlerrtext)
halt;
end if

 

**Clicked event script of my retrieve button

dw_1.SetTransObject(SQLCA)
dw_1.Retrieve()

 

**AEM Data Source Setting

 

**Connection of Application

 

**Error after clicking Retrieve button

 

**I've already tried below interfaces for DBMS except for JDBC Interface but it's still not working.

 

 

  1. SQL Server
Cambio de fecha en datawindow
iis server issue
Accepted Answer
Appeon Support Team
Appeon Support Team Accepted Answer Pending Moderation
  1. Thursday, 9 August 2018 00:46 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Orlando,

Is there any deploy error? Please make sure you had checked correct database type in Toolkit > Application profile > DB Settings > Database Type, and please full deploy application.

If there is still the issue, please provide the deploy log and refer to below article to provide the erver log and error log to us too, thanks.
http://support.appeon.com/index.php?/Knowledgebase/Article/View/50/0/what-you-can-provide-to-us-for-further-debugging-when-you-run-into-the-appeon-server-related-issues

Regards,
ZhaoKai

 

Comment
Orlando Algentera
  1. Orlando Algentera
  2. Thursday, 9 August 2018 06:28 AM UTC
I've fixed the error by updating DB Setting. Thanks for your answer.



  1. Helpful
There are no comments made yet.
Responses (5)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 August 2018 22:00 PM UTC
  2. PowerBuilder
  3. # 1

Hi Orlando,

First, make sure you included the Appeon Workarounds .PBL - the GetClientType() requires that .PBL.

Second, check the "Dynamic Database Connection" option in AEM because it looks like you are passing username/password from the client side.

Third, verify that the UID and PWD you entered is correct.

And finally, modify your code as follows:

SQLCA.DBParm="CacheName='LPPS'"
SQLCA.DBMS = "MSS"
SQLCA.LogId = sa
SQLCA.LogPass = 'password'
SQLCA.AutoCommit = false

Regards,
Armeen 

 

 

Comment
Orlando Algentera
  1. Orlando Algentera
  2. Thursday, 9 August 2018 06:34 AM UTC
Thanks for your answer.

I already included appeon_workarounds.pbl in my library list and my SQLCA setting is the same from your input.



The issue was fixed by configuring DB Setting (particular to MSSQL Server) of my application in PowerServer Toolkit.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 August 2018 19:22 PM UTC
  2. PowerBuilder
  3. # 2

Here is my code ...


//// Profile SS_2017
SQLCA.DBMS = "MSS"
SQLCA.AutoCommit = False
SQLCA.DBParm = "CacheName='SS_2017_Chris'"

Connect using SQLCA;

PS2017 ...


Comment
Orlando Algentera
  1. Orlando Algentera
  2. Thursday, 9 August 2018 06:36 AM UTC
Thanks, Chris.

I've already configured and tested the Data Source and Transaction Objects of my application in AEM.

The issue was fixed by configuring DB Setting (particular to MSSQL Server) of my application in PowerServer Toolkit.
  1. Helpful
There are no comments made yet.
Orlando Algentera
Orlando Algentera Accepted Answer Pending Moderation
  1. Wednesday, 8 August 2018 19:11 PM UTC
  2. PowerBuilder
  3. # 3

 

I got the same error.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 August 2018 19:03 PM UTC
  2. PowerBuilder
  3. # 4

Hi Orlando;

   For the "Web" access, change ...

SQLCA.DBMS = "ODB-MSS"         // to

SQLCA.DBMC = "MSS"

 

FWIW: I can not use any other access mechanisms with SS Express and PS2017. MSS though works great for me when using the "CacheName" approach.

 

HTH

Regards ... Chris

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.