1. JIJO THOMAS
  2. PowerBuilder
  3. Wednesday, 28 July 2021 17:24 PM UTC

Hi Team,

I have using PowerBuilder 17 with Sybase DB connecting via ASE ( Sybase open client 16). Using DB connection method as 'ASE' inside application. Application using functional account to connect the db. sometimes users are getting db connection failed issue from ASE, user id and password is correct but connection getting failed. due to this issue, application functional account getting locked. Requesting to kindly guide me on this issue and let me know if any possible solutions,

Thanks in advance

 

Regards,

Jijo Thomas

PowerBuilder Developer (10+ year )

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 28 July 2021 21:01 PM UTC
  2. PowerBuilder
  3. # 1

Hi Jilo;

   If the connection fails then there should be more detailed information in SQLCA in the form of the Error Code & Error Text values. That information might help you to determine the cause of the DBConnect issue.

  My suspicion is that because it's "random" that your hitting some kind of connection limit set in the DBMS. Your DBA can help there if that's the case.

Regards... Chris

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 29 July 2021 12:38 PM UTC
Hi Jilo ... I've been using the "ASE" connection setting since PB 12.6 and all Appeon releases of PB with ASE 16 with no issues. I'm even testing PB2021 with ASE 16 and no issues.

Sounds like you may not have the most recent ASE 16 DB Client software installed. I would check with your DBA and/or SAP.
  1. Helpful
  1. JIJO THOMAS
  2. Friday, 30 July 2021 10:56 AM UTC
Thank you Chris for your valuable comments. We have checked in SQLCA objects, "login failed "is the error text and SQLCode is -1.

Checked with DBA and got response like "Account Locked by ASE due to failed login attempts".

did we miss any DPParm value specially for ASE

Kindly help me on this case for identifying the solution

Thanks in Advance



Regards,

Jijo Thomas

  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 30 July 2021 13:51 PM UTC
Hi Jilo;

I would suggest that you turn on SQL Tracing & see exactly what user credentials are being passed that are being rejected by ASE.

FYI...

SQLCA.DBMS = "TRACE ASE"

Regards ... Chris
  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 28 July 2021 19:29 PM UTC
  2. PowerBuilder
  3. # 2

Greetings, Jijo -

Have you reviewed/discussed this issue with your Sybase ASE DBA?

Do you have reason(s) to believe the account lockout is being caused by the PowerBuilder application? If so, can you please inform us?

Regards, John

Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 28 July 2021 20:36 PM UTC
Very good points, and usually connection issues are DB driver or DB engine config issues rather than PB problem. So seeking help from DBA is the first thing I would try.
  1. Helpful
  1. JIJO THOMAS
  2. Thursday, 29 July 2021 04:44 AM UTC
Thank you for valuable comments. earlier we used SYC (Sybase open client 12.5

) for connecting the Sybase DB from PB and it was working without any issues.



Now Migrated Sybase open client 12.5 to 16 and using ASE in the build. because SYC having some issues with connecting Sybase open client 16. There is no change in the DB which we used in Open client 12.5 and 16.



We had checked with Sybase DBA , got the response like, multiple failed attempts creates the issue.

if we using open client 12.5 and SYC. there is no issues like this.

issue is only for using open client 16 with ASE.



Kindly help me on this case for identifying the exact root cause.

Thanks in advance.



Regards,

Jijo Thomas
  1. Helpful
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.