1. Greg Harbutt
  2. PowerBuilder
  3. Friday, 25 October 2019 01:07 AM

Can someone please provide guidance on how to configure a database connection to use SSL to a Sybase ASE database?  I need to know how to connect from both the Powerbuilder IDE and, separately, from a client/server application.

We are currently using

  • Powerbuilder Standard 2017 R2 but will shortly upgrade to 2019
  • Sybase ASE 16.0
  • Database Interface: ASE SAP ASE 15.x|16.x

I am able to establish an SSL connection to the ASE database via tools such as Sybase's Interactive SQL and JetBrains' DataGrip.  With both of these I have had to set connection parameters.

  • ENABLE_SSL=TRUE  (required only for DataGrip)
  • SSL_TRUST_ALL_CERTS=TRUE (required only for both Interactive SQL and DataGrip)

 

Suhas Shravagi Accepted Answer Pending Moderation
  1. Thursday, 29 October 2020 09:53 AM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

Greg, I had a kind of similar issue and resolved. Please the resolution here. Hope it will help you.

Thanks!

Comment
There are no comments made yet.
Greg Harbutt Accepted Answer Pending Moderation
  1. Sunday, 27 October 2019 22:23 PM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

Thanks John.  Your answer has the advantage of keeping the driver the same an thus minimising risk.  I will try to get this working soon.

Comment
There are no comments made yet.
Greg Harbutt Accepted Answer Pending Moderation
  1. Sunday, 27 October 2019 22:18 PM
  2. PowerBuilder
  3. # 3
0
Votes
Undo

Thanks Chris.  That looks promising, although I was hoping to keep the native Sybase driver to keep change to a minimum. 

ADO.net is new to me so I will take some time to wrap my head around it.

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Friday, 25 October 2019 14:22 PM
  2. PowerBuilder
  3. # 4
0
Votes
Undo

Greg -

Since PB's ASE driver uses the SAP Open Client Library as the communications conduit between client and server, and since SSL would need to be utilized in that part of communications process, I suspect there may be options in how Open Client is configured, perhaps in the SQL.INI file? A web search found this:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35400.1550/html/osref/osref253.htm

There may not be anything to be configured on the PB side if SSL configuration is accomplished solely in Open Client.

Have you tried asking any ASE forums how to configure Open Client to use SSL?

HTH, John

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 25 October 2019 01:34 AM
  2. PowerBuilder
  3. # 5
0
Votes
Undo

Hi Greg;

  I believe that you would have to use ADO.net for this task. Here is an example.

HTH

Regards ... Chris

Comment
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.