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

Resolved PowerServer not generating SQLCA error VS PB code that does...

  1. Issue
0
Votes
Undo
  1. J-Craig Maxie
    J-Craig Maxie
  2. PowerServer 2020 or older (Obsolete)
  3. Wednesday, 22 August 2018 21:14 PM UTC

PowerBuilder 2017 R3 and PowerServer

Same code - I ran as a PowerBuilder app and the code (correctly) generated a SQLCA error when CONNECTing to the database, yet running as PowerServer Web did not get an error.  I purposely used an invalid password in both cases, so should have generated a SQLCA error code.  Is it possible that by having to specify a valid DataSource before deploying the PowerServer code, it's fooled into thinking "all-is-well"?

Note that we are connecting to an Oracle database via the Native Interface, and that valid UserID/passwords are actually valid Oracle UserID/passwords.  That is, there's no table(s) to check for valid credentials.

PowerServer Web and NativePDF - print margins are ...
Can't install PowerServer
Responses (3)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 23 August 2018 02:29 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi,

The SQLCode is different from PowerBuilder where -1 will be returned, it is recommended to use < 0 as the evaluation value for errors in both PowerBuilder and Appeon.

Please refer to chapter below in PowerServer online help for more detail.
https://www.appeon.com/support/documents/appeon_online_help/2017/features_help_for_appeon_web/ch05s02s01.html#d0e39983

Regards,
ZhaoKai

Comment
There are no comments made yet.
J-Craig Maxie
J-Craig Maxie Accepted Answer Pending Moderation
  1. Wednesday, 22 August 2018 21:46 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Greetings Armeen - yes, bothLogID and LogPass are properly populated.  However, "Dynamic Database Connection" was not enabled.  Once I did so, it generated a SQLCode error (-2146232008)... Perfect!  Should I be concerned about that unusual error code?

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 22 August 2018 22:53 PM UTC


Hi;

That's a weird code but anything less than 0 means an error. The real problem should be reflected in the SQLCA.DBCode and SQLCA.DBErrText fields of the transaction object.

HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 22 August 2018 21:32 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

Have you assigned the username and password to LogID and LogPass properties?

Have you enabled the "Dynamic Database Connection" option in AEM?

 

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.