1. Ninad Pethe
  2. PowerBuilder
  3. Wednesday, 10 June 2020 17:10 PM UTC

Hello Team, 

I have desktop application developed in PowerBuilder 2017 R3, which is connecting to Sybase ASE 15.7 database. Before connecting to the database I am setting SEC_CONFIDENTIAL=1 to dbParm property as below. 

sqlca.DBMS="SYC"

SQLCA.dbParm="EncryptPassword='True',Release='15.7',Sec_Confidential=1"

When I try to connect to database it throws error "Cannot Connect to Database. Connection Denied. Attempt to set CS_SEC_CONFIDENTIALITY connection property failed."

Could you please help to resolve this error. Is there any syntax issue OR do I need to set additional parameter. 

Thanks,

Ninad

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 10 June 2020 17:25 PM UTC
  2. PowerBuilder
  3. # 1

Hi Ninad;

   FYI: The "SYC" DB driver option is not for Sybase ASE 15.7. Instead, you should be using ...

SQLCA.DBMS = "ASE"

SQLCA.DBParm = " Release='15.5' "

HTH

Regards ... Chris

Comment
There are no comments made yet.
Ninad Pethe Accepted Answer Pending Moderation
  1. Thursday, 11 June 2020 08:32 AM UTC
  2. PowerBuilder
  3. # 2

I change the properties as per your suggestion, but still getting the same error when setting "SEC_CONFIDENTIAL=1"  to dbParm property as below. 

sqlca.DBMS="ASE"

SQLCA.dbParm="EncryptPassword='True',Release='15.5',Sec_Confidential=1"

 

Error Message :

"Cannot Connect to Database. Connection Denied. Attempt to set CS_SEC_CONFIDENTIALITY connection property failed."

 

Thanks,

Ninad

 

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 11 June 2020 15:41 PM UTC
If I remember correctly, you may need a special ASE "client" that has that feature enabled. I would now check with your DBA and/or SAP support if that is a requirement.
  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 11 June 2020 13:39 PM UTC
  2. PowerBuilder
  3. # 3

What version of Sybase OpenClient are you using? It should roughly correspond to the Sybase RDBMS version. it's been many years since I use a Sybase ASE database.

Is there anything in OpenClient that needs to be configured? Can you connect securely to the database using just OpenClient? Once you can create a secure connection outside of PB, then you can tackle getting a secure connection from PB.

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 11 June 2020 15:10 PM UTC
  2. PowerBuilder
  3. # 4

Section 8.6.3 of the PB Connecting To Your Database publication discusses using Open Client Security Services. It sounds like The DBParm string also needs to include the Sec_Mechanism (security mechanism) setting. I suggest you read this information to see what additional settings you may need to include in your connection string.

https://docs.appeon.com/appeon_online_help/pb2019r2/connecting_to_your_database/ch08s06.html#d0e3586

I think the best way for you to proceed is to first verify that you can establish a secure connection to the ASE database through Open Client configuration and the ISQL or SQL Advantage tools. Once working, then you can focus on establishing a secure connection through PB.

Comment
  1. Ricardo Jasso
  2. Thursday, 11 June 2020 16:32 PM UTC
According to the documentation mentioned by John, you need a "SAP-supplied security driver properly installed and configured for your environment" . I believe that's something you need to buy from SAP.
  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.