• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PowerBuilder connection thru specific Sybase Client version

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

Resolved PowerBuilder connection thru specific Sybase Client version

  1. How-to
0
Votes
Undo
  1. Suhas Shravagi
    Suhas Shravagi
  2. PowerBuilder
  3. Thursday, 29 October 2020 09:46 AM UTC

Hi,

 

My PowerBuilder desktop application (developed in 2017 R3) connects with the Sybase database. I am using "SYC" DBMS for connection. Now the situation is I have two different versions of Sybase client installed on my machine i.e. v15.7 and v16.0. Now I need to enforce my PowerBuilder application to connect to database using Sybase Client v16.0 only (and not 15.7.) I tried setting release parameter as 16 in DBParam property of SQLCA as below:

SQLCA.DBMS = "SYC"

SQLCA.dbParm="EncryptPassword='True',Release='16'"

But I am not sure whether it is connecting with 16.0 only because when I tried to put any random value for release, still the application was connecting with the database. Can someone help here.

Please note, we can't remove Sybase Client 15.7 as it is being used by other applications. Thanks!

How can I get around the Row Size Problem with Sup...
PowerBuilder is not able to Create/Access OLE obje...
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 29 October 2020 15:55 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Suhas;

 FYI: Sybase dropped support for the "SYC" DB Client a long time ago for both ASE v15 and higher as well as in PowerBuilder's DB interface drivers. So for Appeon PB with ASE v16, please use the "ASE" DB Client as John correctly pointed out. Also, please make sure that you set the proper release number in the DBParm field of SQLCA.

Regards ... Chris

Comment
There are no comments made yet.
Responses (2)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 29 October 2020 13:30 PM UTC
  2. PowerBuilder
  3. # 1

Have you tried using the alternative and newer Sybase Adaptive Server Enterprise driver (SQLCA.DBMS="ASE")?

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.