Error 7216 even after D word added ADS 12.0.02 and Windows Server 2008

[tcutlip]

We are having an issue at a customer site where we have Advantage version 12.0.2 installed on a Windows 2008 server. Even though we have added the D word for unlimited SQL statements we continue to run into the Advantage error.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration add a DWORD key named SQL_STATEMENT_LIMIT and set it to the required value (e.g. 0 for disabled). ADS was re-started after this setting was changed.

Having trouble adding an incident to get assistance on this. Anyone have any suggestions on how from a support perspective we can address this issue?

[michael_loop]

A support incident was opened for this. It turned out to be a typo in the registry entry.

[joachim_drr]

you need to set the limit for the actual connection aswell:

execute procedure sp_SetStatementLimit(0)