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

Resolved PowerServer Sybase ASE SSL connection using ASE Native Driver

  1. How-to
0
Votes
Undo
  1. Nilotpal Bera
    Nilotpal Bera
  2. PowerServer 2020 or older (Obsolete)
  3. Tuesday, 12 January 2021 15:28 PM UTC

Hi,

Greetings!

We are trying to establish a SSL connection with Sybase ASE database server using PowerServer Web/AEM.

The driver we intend to use is ASE Native Driver.

But after providing connection values, the testing of datasource keeps on failing.

We have entries for SSL in the SQL ini file.

Do we need to provide something using DBParm as well from the PowerBuilder client application.

 

Any help/advice much appreciated!!

 

Environment:

PowerBuilder 2019 R2 Build 2353

PowerServer (PB Edition) 2020 Build 2323 64 Bit

Windows Server 2012 R2

.Net Application server

Sybase ASE 16

 

Thanks,

Nilotpal

 

 

PowerServer crossbrowser plugin pre-installation
Stored procedure call 1st input argument us not su...
Accepted Answer
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 13 January 2021 08:16 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Hi Nilotpal,

We have no experience in ASE SSL, but MS SQL Server SSL works well by adding parameter 'Encrypt=yes;TrustServerCertificate=yes' into extended options in AEM data source(as shown as attached). Please refer to article below below for details about extended options in AEM data source.https://docs.appeon.com/ps2020/server_configuration_guide_for_net/Resources.html#Adding_connection_cache

Please try adding related parameters into extended options in AEM data source to see if it works well. If there is still the issue, please try ASE ODBC driver, you can configure SSL in the security tab in the ODBC data source profile.

Regards,
ZhaoKai

Attachments (1)
ExtendedOptions.png ExtendedOptions.png
Comment
Load more comments
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Tuesday, 19 January 2021 00:11 AM UTC
Hi Nilotpal,



Glad to hear that! Sorry that there is no way to add this line while creating the datasource dynamically, please add this line munually.



Regards,

ZhaoKai
  1. Helpful
Nilotpal Bera
  1. Nilotpal Bera
  2. Friday, 22 January 2021 06:56 AM UTC
Hi ZhaoKai,



Just need to confirm that will this datasource Extended Options feature be available for dynamic usage in the next PowerServer 2021 release.



Thanks,

Nilotpal
  1. Helpful
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Friday, 22 January 2021 09:01 AM UTC
Hi Nilotpal,



PowerServer 2021 has a different framework comparing with PowerServer 2020. The server runtime of PowerServer 2021 adopts a cloud-native architecture and supports the cross-OS .NET Core framework, which supports ASE ODBC driver only. We will continue to study the support for ASE Native driver on PowerServer 2021.



In PowerServer 2021, you cannot run applications on browsers, you can access Appeon Cloud Applications using IWA. Please read the Discontinued Features Announcement here:

https://www.appeon.com/developers/discontinued-features-in-powerserver-2021



We understand it takes time to transition off discontinued features. As such, we will provide long-term support for PowerServer 2020.x. Please carefully read the Long-Term Support Announcement here:

https://www.appeon.com/developers/lts-designation-of-powerserver-2020



Regards,

ZhaoKai
  1. Helpful
There are no comments made yet.
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 12 January 2021 16:07 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Configuration for the database is done in AEM not in your PB app or INI file.  Also, the documentation states that only ASE 15.x is supported right now so not sure if that is also part of your problem.  Here is instructions how to setup ASE with native driver in AEM: https://docs.appeon.com/ps2020/server_configuration_guide_for_net/connection_cache_settings_for_ASE_native_driver.html

 

Comment
Nilotpal Bera
  1. Nilotpal Bera
  2. Tuesday, 12 January 2021 16:50 PM UTC
Hi Armeen,

Thanks for the quick reply.

I am able to successfully create and connect to the PowerServer datasource dynamically from the PB app itself and that too using the ASE Native Driver for Sybase ASE 16 version database. Thanks to the workarounds pbl provided.

The problem comes when we try to invoke a SSL connection to database server and port.



Thanks,

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