[Bugzilla user: sprog@mail.ru]
[Bugzilla date: 2024-03-05T05:52:13+00:00]

Any lookup by Orthanc Explorer or Orthanc Explorer 2 fails with error.

E0305 08:27:05.266052           HTTP-0 PluginsManager.cpp:153] Error with the database engine: Cannot execute ODBC statement:
42000 : 1/102 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'.
42000 : 2/8180 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.

Configuration file:

    "Odbc" : {
        "EnableIndex" : true,
        "EnableStorage" : false,
        "IndexConnectionString" : "Driver={ODBC Driver 17 for SQL Server};Server=tcp:localhost,1433;Database=Orthanc;Uid=...;Pwd=...",
        "StorageConnectionString" : "DSN=storage",
	"IndexConnectionsCount" : 1
    }

All studies lists as expected. Error flow up only when query contain count limitation.