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

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

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.

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.