bildwelt
E2E FORUM
E2E Bridge E2E Commerce

Reply To: Error opening database cursor

E2E Forum Modeling & Development Error opening database cursor Reply To: Error opening database cursor

#1934

Alfred
Moderator

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?