Thank you for the test model. I can reproduce the error.
If you use <<SQLAdapter>> getHandle the following
cursor options are set to enable server cursors:
– SQL_ATTR_CURSOR_TYPE: SQL_CURSOR_DYNAMIC
– SQL_ATTR_CONCURRENCY: SQL_CONCUR_LOCK
According to Microsoft documentation https://msdn.microsoft.com/en-us/vstudio/ms403282(v=sql.90) some
SELECT statements cannot use clauses not supported by server cursors: COMPUTE, COMPUTE BY, FOR BROWSE, and INTO
So in this case you have to stick to <<SQLAdapter>> execute. If the result set is not to large you shouldn’t run into problems.
Is the workaround acceptable for you?