1. Bryant Burnard
  2. PowerServer 2020 or older (Obsolete)
  3. Wednesday, 8 May 2019 20:43 PM UTC

Hi;

I'm using PF2017 R3 Build 1858, deploying to PowerServer via IIS, using Oracle instant client 18.3 64 bit, running in Chrome 74.0.3729.131 64 bit. The transaction object uses a dynamic connection to log on.

When a client logs in we test to see if their account is set to Expired via the dbparms set to: SQLCache=0,PWExpDialog=1,PWDialog=1

In PB client this works fine, and the PWDialog pops up.

When I try this in PowerServer, I'm getting different behaviour, the SQLCode error isn't 28001, but minus -2146232008, I have to Pos the SQLErrText to check for ORA-28001. I can then use a service account to login to the app, change the password, and then log out, with user having to log back in with the updated user password.

The issues I'm curious about are:

Why doesn't the PWExpDialog=1,PWDialog=1 behave the same in PowerServer.

In order for the service account to log in, I have to issue a disconnect, which throws an error saying not connected, then issue a connect. (If I don't issue the disconnect the service account doesn't seem to be able to connect, I checked using a select sysdate from dual, and I'm not connected) Is there a way to reconnect without the disconnect? 

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 9 May 2019 00:11 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Bryant;

  As per the PowerServer documentation ... The following DBParm parameters are supported: CommitOnDisconnect, CacheName, DelimitIdentifier, DateTimeAllowed, DisableBind, NCharBind, TrimSpaces and Identity.

 All other DBParm settings not listed above are not supported by PowerServer.

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