Does your code not have a transaction?
Even SQL server itself only works with transactions. You can't do anything without it.
Yes, it has a TSQLTransaction connected to a TODBCConnection, as I have shown in the first post,
and I've also tried various hacks to get around the problem, but failed...
Without it, there is no chance to get data from a TSQLQuery.
About SqlLite, I don't know if it will work... Does ODBC would be involved ? Otherwise I don't see the point...
So far, I've experienced bad feelings wrt SqlServer support, the only 'reliable' way I've found so far has been to *rewrite*
the thin client layer throu ADO (ComObj etc...). Now debugging memory leakage etc...