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

Resolved Database Profile Setup issue

  1. Issue
0
Votes
Undo
  1. Suhas Shravagi
    Suhas Shravagi
  2. PowerBuilder
  3. Thursday, 6 August 2020 10:37 AM UTC

Hi,

 

I setup a database profile thru PowerBuilder IDE (2017 R3.) Wnen I check the "Encrypt All Results" option under Security tab (as below screen) and test the connectivity, it throws the error mentioned in second screenshot. Can you help in sorting out the issue? If I uncheck this option and test, the connection is successful.

 

 

The complete connection string generated is as:

SQLCA.DBParm = "Release='15',CommitOnDisconnect='No',Sec_Confidential=1"

 

--Thanks.

datawindow SaveAs XLSX! with column that has more ...
project build options - rebuild - incremental grey...
Accepted Answer
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 6 August 2020 13:46 PM UTC
  2. PowerBuilder
  3. # Permalink

Greetings, Suhas -

Have you met all of the requirements for using OpenClient security services, as outlined in the Appeon PB publication "Connecting To Your Database" section 8.6.2? Here is a link to that section in the online documentation:

https://docs.appeon.com/pb2019r2/connecting_to_your_database/ch08s06.html#Requirements_for_using_Open_Client_security_services

Regards, John

Comment
There are no comments made yet.
Responses (5)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Saturday, 8 August 2020 02:14 AM UTC
  2. PowerBuilder
  3. # 1

See also:

https://community.appeon.com/index.php/qna/q-a/query-in-sybase-ase-15-7-for-powerbuilder-2017

You set the dbparm "Release" to 15, but maybe you'd have to set it to the exact version, like for example 15.7 ?

I think this feature started with 15.7. Maybe if your release is earlier, it just won't work.

HTH

Comment
There are no comments made yet.
Suhas Shravagi
Suhas Shravagi Accepted Answer Pending Moderation
  1. Friday, 7 August 2020 08:01 AM UTC
  2. PowerBuilder
  3. # 2

Chris,

 

Yes, the encryption feature for Sybase ASE is installed on the server.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 7 August 2020 14:53 PM UTC
Super ... did you install the corresponding ASE DB Client part?
  1. Helpful
Suhas Shravagi
  1. Suhas Shravagi
  2. Thursday, 13 August 2020 11:12 AM UTC
Checking with DBA... Will update you once we receive any response from them.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 August 2020 14:20 PM UTC
  2. PowerBuilder
  3. # 3

Hi Suhas;

   The ASE encryption feature is not provided within the base ASE version. Instead, it is an extra purchased option. Sounds like the issue might be related to the fact that this feature is not yet installed.

Regards ... Chris

Comment
There are no comments made yet.
Brad Mettee
Brad Mettee Accepted Answer Pending Moderation
  1. Thursday, 6 August 2020 13:45 PM UTC
  2. PowerBuilder
  3. # 4

You also asked about this back in June (link here). 

Have you contacted SAP about this directly yet?

 

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.