Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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

0 Kudos

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

execute procedure sp_SetStatementLimit(0)