Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved TLS1.2 to connect to database server

  1. How-to
0
Votes
Undo
  1. Suhas Shravagi
    Suhas Shravagi
  2. PowerBuilder
  3. Tuesday, 6 October 2020 08:09 AM UTC

Hi,

My desktop application (built in PB 2017 R3) is connecting to Sybase ASE 15.7 database thru OpenSSL with below configuration:

SQLCA.database = ls_ApplDataBaseName
SQLCA.servername = "MyServerName"
SQLCA.logid = ls_ApplLoginID
SQLCA.logpass = ls_ApplLoginPassword
SQLCA.DBMS = "SYC"
SQLCA.autocommit = TRUE
SQLCA.dbParm="EncryptPassword='True'"


sql.ini structure at client:

[MyServerName]
master=TCP,server.xyz.net,10001 ssl
query=TCP,server.xyz.net,10001 ssl

With this configuration, my application is connecting successfully with the database, it is also encrypting the traffic. However, it is connecting with protocol TLS1.0. This protocol is obsolete now. The need is to connect with TLS1.2 protocol. The TLS1.2 is enabled on server. Is there anything to be done in PowerBuilder code so that it will implement TLS1.2 while establishing connection?

Thanks!

 

  1. Database
  2. PowerBuilder
  3. TLS/SSL
Getting value from DW with editmask
How do you configure SSL to Sybase ASE database
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 6 October 2020 14:19 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Suhas;

  I would check with SAP's ASE Support team. You might have to upgrade to ASE 16.x or use a different DB Client.

Regards ... Chris

Comment
Suhas Shravagi
  1. Suhas Shravagi
  2. Wednesday, 7 October 2020 19:42 PM UTC
I think there must be some configuration to be enabled at sybase client to enable TLS1.2, but not sure exactly what.
  1. Helpful
There are no comments made yet.
Responses (2)
Suhas Shravagi
Suhas Shravagi Accepted Answer Pending Moderation
  1. Saturday, 31 October 2020 19:50 PM UTC
  2. PowerBuilder
  3. # 1

We upgraded the Sybase client to version 16 and the issue got resolved. Now the connection between Client and the db server is encrypted with TLS1.2. No changes in PowerBuilder.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Saturday, 31 October 2020 20:12 PM UTC
Hi Suhas;

That is "awesome" news! :-)

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