sp_helptext SYBASE

[deugene]

Good afternoon. I would like to especially thank the authors for an excellent product. Faced with the problem that if a request form to MSSQL sp_helptext <StoredProcName> runs fine, then for Sybase returned only that the request is made but no result.

[Serge]

Hello!

I guess problem is in JDBC driver or protocol differences between MSSQL and Sybase. Maybe Sybase do not signals about resultset availability when you execute stored procedures.
Could you say what driver do you use (jtds or MS)?

Unfortunatelly right now I don't have access to live Sybase server to test this issue. As soos as I get I'll try to fix this problem or at least make some workaround for particular driver.

Thanks for report!

[deugene]

[Serge]

The problem is that I never tested it with real Sybase server. I guess SQirrel has some kind of workaround.
I had some assumptions about the nature of this problem so I did changes in resultset retrieving code. Could you check latest EA version? (). Maybe it'll help. If so then this fix will be included in 1.6 release.

Note: EA version contains many other changes, and may contain other bugs. But generally it is stable.

[deugene]

Unfortunately did not help. The main object is seen but can not handle the result as can be seen. a squirrel

[Serge]

Hello,

I seean error in status line: "Object doesn't exist in thisdatabase". It is standard errror whenSybase can't findprocedure you are trying to view.
I think it is not a result that DBeaver doesn't fetch rows from procedure. Are you absolutely sure that you have the same connection properties, current schema, etc as in squirrel? Did you tried the same in other SQL tools?

Thanks