You can translate the question and the replies:

JDBC Data source Driver -Sybase ASE 16

**May I ask which dirver is prefered for Sybase ASE 16. ** As below document, it only provide 12 and 15. We tried with jTDS driver. but when connect denodo view in PowerBI, it report error: ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.. Changed the driver as 'com.sybase.jdbc4.jdbc.SybDriver', in denodo, it report error: JZ006: Caught IOException: JZ0PA: The query has been cancelled and the response discarded.
02-07-2020 01:27:25 -0400

1 Answer

Hi, In order to connect to the Sybase ASE 16, you could use the 'Sybase Adaptive Server Enterprise15' adapter. For the driver class, either you can use the Sybase driver or the jTDS open source driver. In your case, I would check if the view execution is successful in the Virtual DataPort Administration tool. If it fails only in PowerBI, then I would check the log files **vdp.log** and **vdp-requests.log** located in path <DENODO_HOME>\logs\vdp by changing the log level to 'INFO' in order to debug the issue. You could refer to the KB article [How to log the requests issued on a VDP server]( for more information. Additionally, if you are a valid support user and need further assistance, you could open a [Support case]( stating your problem. Hope this helps!
Denodo Team
02-07-2020 08:37:48 -0400
You must sign in to add an answer. If you do not have an account, you can register here