I am using the trial version of QuickBooks Online ODBC (QODBC) driver and configured the DSN named QuickBooks Online Data as well as QuickBooks Online Data QRemote

I have ensured the connection using the test tool and I am able to execute the SQL queries properly using the mentioned test tool and C# code.

Please find some of the example queries that works fine:

select * from Account

select account.TimeCreated,account.TimeModified, TaxRate.ListID from account
left outer join TaxRate on account.ListID = TaxRate.ListID

select AVG(RateValue),SUM(RateValue) from TaxRate

select Top 5 ListID,RateValue from TaxRate

While trying to execute the subqueries in the test tool, I am facing the following issue.

Subquery used:

select ListID from (select ListID, TimeCreated from Account)

Exception: ERROR [42S00] ExecDirect Packet Header - Received Error:10054, An existing connection was forcibly closed by the remote host. This normally results if the peer application on the remote host is suddenly stopped, the host is rebooted, the host or remote network interface is disabled, or the remote host used a "hard close"

ERROR [42S00] Error Invalid Socket. Either socket is closed, or the socket reference is invalid. For more information please visit: qodbc.com/links/invalidsocket

I have tried the suggested solution in the error message, still, the issue is not resolved.

Also, tried the subquery execution in the c# console application as well and faced the same issue.

Anyone, please let me know the possible solution to resolve this issue?