Bug 3339

Powerbuilder native connection using TLS 1.2 14 January, 2021

John Rollins
16 September, 2019
Product: PowerBuilder Category: Database
Version: 2019 Build:
Classification: Enhancement Publishing: Public
Priority: P1
Status: Closed Reason: RECORDED AS ENHANCEMENT
Zhao Kai @Appeon 14 January, 2021
#4
Hi SanjayS,

There is no change in code to the support for TLS 1.2 comparing to the previous SSL. You need to specify the Encrypt and TrustServerCertificate parameters in DBParm, for example:
// Profile sqltls
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = "xxxx"
SQLCA.ServerName = "xxxx"
SQLCA.LogId = "xxxx"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='test',Provider='SQLNCLI11',Encrypt=1,TrustServerCertificate=1"

Please refer to the article below for details. 
https://docs.appeon.com/pb2019r2/connection_reference/ch01s01.html#Encrypt
https://docs.appeon.com/pb2019r2/connection_reference/ch01s01.html#XREF_66907

Please note that it is required that both database server and client driver support TLS 1.2. Please refer to the article below for more detail about the TLS 1.2 support for Microsoft SQL Server.
https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server

If there is any issue when connecting to database server via TLS 1.2, please refer to the article below to solve it.
https://community.appeon.com/index.php/qna/q-a/tls-1-2-when-using-snc-sql-native-client-ole-db-as-dbms-for-transaction 

Regards,
ZhaoKai
Sanjay Shivade 13 January, 2021
#3
I need to test TLS 1.2 support in PB 2019 R3 version which supports it but not sure what exactly am I supposed to do?

Could you let me know if there are any code changes like connection string etc. is needed? 

Do you have any documentation that I can refer to ?

Thanks
SanjayS
Appeon Product 09 December, 2020
#2
Hi John,  

 

Thank you for submitting the ticket.  

We now acknowledge this ticket to be an enhancement request and will record and track it internally in our enhancement management system. At the same time, we are closing the ticket here because this support system is for handling standard support services but not for maintaining enhancement requests.  

Please note that despite its "Closed" status, you are welcome to come back here and leave further comments or query the relevant development progress on this ticket.  

 

Regards,  

Amy Feng
Ken Guo @Appeon 16 September, 2019
#1
Hi John,

Thanks for reporting this problem. 
We'll transfer this enhancement to our product team for consideration. 

Regards,
Ken
John Rollins 16 September, 2019
*Phenomenon:
Our customer has turned off TLS 1.0 support on their servers. PowerBuilder will now not connect to the database giving a "SSL Security Error". This is not a SOAP/REST service, but the SQLCA connection. We are currently using SQL Native client and need to quickly switch providers/drivers. Which provider can support TLS 1.2?

*Reproduce Steps:


Remarks:
OS:
Windows 10
Platform:
32-bit
Database Type:
Microsoft SQL Server
Database Version: