• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Software being used to interact with Sybase ASE database

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

Resolved Software being used to interact with Sybase ASE database

  1. Advice
0
Votes
Undo
  1. David Vasconcelos
    David Vasconcelos
  2. PowerBuilder
  3. Tuesday, 12 March 2019 11:55 AM UTC

Just trying to find out what software people are using to interact with a Sybase Database (ASE 16).

We are using Infomaker (12.5, 2017) and DBeaver, unfortunately they do not list user functions.  Not sure what others are using but if you have a few minutes please let me know the software and any features you like that the software provides, also if its free vs cost.

Thanks in Advance...

Dave V.

Datatype Any used in assembly
How to connect SAP S/4 HANA?
Responses (5)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 14 March 2019 19:02 PM UTC
  2. PowerBuilder
  3. # 1

Hi David;

   I just tested ASE 16 and SS2017. You cannot see the SF's in the DB Painter in PB2017R3 or PB2019 when connected to ASE. You can create, alter, drop or execute them. You just cannot see them in the DB Painter's "System Tree"

  However, SF's are fully viewable when connected to SS2017 in the same PB or IM PB Painter. Looks like this is an ASE bug to me from the PB ASE driver POV.

HTH

Regards ... Chris

 

Comment
David Vasconcelos
  1. David Vasconcelos
  2. Tuesday, 26 March 2019 16:28 PM UTC
Chris, can't see your picture...by the way what is SS2017?
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 26 March 2019 16:31 PM UTC
Yes, it is! ;-)
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 12 March 2019 19:17 PM UTC
  2. PowerBuilder
  3. # 2

Hi Dave;

  If you are looking for some more User Functions for IM.

They are free & open source.

HTH

Regards ... Chris

Comment
Roland Smith
  1. Roland Smith
  2. Tuesday, 12 March 2019 19:32 PM UTC
I think he is talking about the database painter not showing user defined functions. It is showing them for me with SNC SQL Server. He is using Sybase ASE.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 12 March 2019 19:39 PM UTC
Hi Roland;

You could be correct. David's post is a bit ambiguous.

I am not sure about the ODBC connection options, but using the "ASE" native connection in either IM or PB should should show UF's - just like in SS - in the DB Painter.

Regards ... Chris
  1. Helpful
David Vasconcelos
  1. David Vasconcelos
  2. Wednesday, 13 March 2019 18:58 PM UTC
Roland is correct, we are not seeing user functions in IM or PB. We can "create" them but unless you know they exist you can't see them. Roland mentioned the ASE.sql file, have not had a chance to look for it to see if that will update IM/PB so we can see them.. If you have any other Idea's let me know and thanks for the response..both of you.
  1. Helpful
There are no comments made yet.
Brad Wery
Brad Wery Accepted Answer Pending Moderation
  1. Tuesday, 12 March 2019 15:20 PM UTC
  2. PowerBuilder
  3. # 3

 

 

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 12 March 2019 15:06 PM UTC
  2. PowerBuilder
  3. # 4

There is a SQL script in the install that you can run that improves the database painter's interaction with Sybase ASE.

Look in the 'Server' folder. Use PBSYC.SQL for the SYC interface or ASE.SQL for the ASE interface.

Not sure if it will help.

Comment
Geoff Gloeb
  1. Geoff Gloeb
  2. Friday, 17 May 2019 12:38 PM UTC
Can you point me to the "server" folder? I have installed PB 2017R3 and I can't find the folder or two scripts.
  1. Helpful
There are no comments made yet.
Kevin Ridley
Kevin Ridley Accepted Answer Pending Moderation
  1. Tuesday, 12 March 2019 14:13 PM UTC
  2. PowerBuilder
  3. # 5

Why not use PB2017?

Comment
David Vasconcelos
  1. David Vasconcelos
  2. Tuesday, 12 March 2019 14:43 PM UTC
has the same limitations as Infomaker, can't see functions for one, thanks for the reply.
  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.