Please use correctly ODBC norm in order to support more DB

simon aubert

2 years ago

Hello all,

I tried to connect Flyspeed and Active Query Builder in Alteryx to MonetDB through ODBC.

At every time, the monetdb server gave me this kind of messages :

and the client (Flyspeed or Alteryx) ends without any result.

I think Active DB should at least use the ODBC norm functions when it exists. such as the one described here :
https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/odbc-api-reference?view=sql-server-ver16

This would widely help for interoperation and expand your software use cases.
The same issue with the Active Query Builder in Alteryx. The topic is widely discussed here :
https://github.com/MonetDB/MonetDB/issues/7313

Best regards,

Simon