1. David Vasconcelos
  2. PowerBuilder
  3. Wednesday, 18 March 2020 17:16 PM UTC

Anyone know where the error log file is?  Where having issues where our PB app is losing its connection to Sybase and I wanted to see what the log has in it.

Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 19 March 2020 02:01 AM UTC
  2. PowerBuilder
  3. # 1

According to the documentation:

$SYBASE/$SYBASE_ASE/install/server_name.log

I haven't used ASE in 4 or 5 years so don't have access to a server to check it myself.

Comment
There are no comments made yet.
David Vasconcelos Accepted Answer Pending Moderation
  1. Thursday, 19 March 2020 10:13 AM UTC
  2. PowerBuilder
  3. # 2

Thanks Roland, I did find the document earlier but I don't see that directory.  I am looking for the client side log and not the server log.

Comment
  1. Roland Smith
  2. Thursday, 19 March 2020 21:00 PM UTC
There isn't an ASE client log. You need to use the TRACE option. See John's answer.
  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 19 March 2020 14:23 PM UTC
  2. PowerBuilder
  3. # 3

Greetings, David -

Are you referring to the database trace file produced by PowerBuilder?

If so, it is produced only when the "trace" option is specified in the transaction object's DBMS property before you connect to the database.

In your code, instead of:

SQLCA.DBMS = "ASE"

specify:

SQLCA.DBMS = "TRACE ASE"

along with all of the other, normal property settings, then issue the normal:

CONNECT USING SQLCA;

When you run the application, a window will prompt you for the name and path of the trace file to be created.

Regards, John

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.