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.

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.

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

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