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

Resolved Query in Sybase ASE 15.7 for Powerbuilder 2017

  1. How-to
0
Votes
Undo
  1. Vanlalpeka Ralte
    Vanlalpeka Ralte
  2. PowerBuilder
  3. Thursday, 21 March 2019 11:47 AM UTC

Hi Team,

We have Sybase ASE 15.7 version. Will it be supported by Powerbuilder 2017? And please let me know what  do you mean by using ODBC. Do I require to install Sybase ODBC --> open client on my machine to get the connection to my DB server?

Also Can you please let me know where I can get ODBC for Sybase ASE 15.7 and how to use that with Powerbuilder 2017 to get the connection?

Step over,single step doent work with exceptions ...
Max screen resolution for PB12 apps in Win 10?
Responses (5)
James Beck
James Beck Accepted Answer Pending Moderation
  1. Monday, 22 July 2019 20:35 PM UTC
  2. PowerBuilder
  3. # 1

Roland, do you know where you are able to download Sybase Open Client?   do you need an account with SAP?

 

Thanks
Jim

Comment
Roland Smith
  1. Roland Smith
  2. Monday, 22 July 2019 20:39 PM UTC
Sybase Open Client comes with the database, your DBA should be able to provide you an installer.
  1. Helpful
There are no comments made yet.
Vanlalpeka Ralte
Vanlalpeka Ralte Accepted Answer Pending Moderation
  1. Thursday, 28 March 2019 17:21 PM UTC
  2. PowerBuilder
  3. # 2

Hi Chris/Roland,

We had tried it with DBMS = "ASE"

But we are still getting the same error - Error Loading Client Library DLLs.

 

Any advise?

 

 

Attachments (1)
ASE.JPG ASE.JPG
Comment
John Fauss
  1. John Fauss
  2. Thursday, 28 March 2019 17:50 PM UTC
Have you installed and configured Sybase Open Client on your PB development machine, as Roland informed you in the first response. PB's ASE database driver communicates directly with Sybase Open Client. You'll likely need some of the setup/configuration values for Open Client when you define the ASE connection parameters in PB.
  1. Helpful
Vanlalpeka Ralte
  1. Vanlalpeka Ralte
  2. Thursday, 4 April 2019 16:20 PM UTC
Hi John,

Thank you for the response. Can you please let me know how to setup/configure values for Sybase Open Client in PB development meachine?
  1. Helpful
There are no comments made yet.
Vanlalpeka Ralte
Vanlalpeka Ralte Accepted Answer Pending Moderation
  1. Thursday, 21 March 2019 14:14 PM UTC
  2. PowerBuilder
  3. # 3

Hi Chris,

 

I am still getting the error- Error loading client library DLLs.Unable to connect to server after making the change.

I have insert the attachment as well. Can you please let me know if I am missing anything? 

 

 

Attachments (2)
Power_Builder_Error.JPG Power_Builder_Error.JPG
DBPARM.JPG DBPARM.JPG
Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 21 March 2019 14:35 PM UTC
Hi Vanlalpeka;



You are trying to use the old SYC DB Client that is now obsolete. If your just trying to connect via the DBProfile Painter (as your screen capture suggests) - please use the Interface labeled "ASE SAP ASE 15.x|16.x" and connect to your ASE instance via that mechanism.



HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 21 March 2019 13:40 PM UTC
  2. PowerBuilder
  3. # 4

Hi Vanlalpeka;

   Yes, its supported already in PB2017 - even ASE 16 ... just set your DBParm:

// For example
SQLCA.DBMS = "ASE"
SQLCA.DBParm = "Release='15.7'"

 

HTH

Regards ... Chris

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 21 March 2019 12:20 PM UTC
  2. PowerBuilder
  3. # 5

PowerBuilder comes with a native interface to Sybase Open Client. 

If you look at the Database Profile window, it is the second from the top choice: ASE SAP ASE 15.x|16.x. In your app set sqlca.DBMS to "ASE".

All you need is to have Sybase Open Client installed and your server configured in it. No need for the ODBC driver.

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.