I my application there is a complex Select-Statement which returns about 1000 records by using Delphi TDBGrid and TMSQuery. If the user doesn't scroll to the end of Grid, this data will occur an Error "ASYNC_NETWORK_IO" on the MSSQL Server.
The data is not editable. Is there any solution to solve and prevent this effect i.e. by Setting an IsolationLevel ?
Thanky for your Feedback.
ASYNC_NETWORK_IO
Re: ASYNC_NETWORK_IO
I am using "FetchAll=False" in this Query.
Re: ASYNC_NETWORK_IO
To solve the issue, try the following:
1. A similar issue is described in the MSDN blog: http://blogs.msdn.com/b/joesack/archive ... ected=true . Try the suggestions from this article.
2. Try using Snapshot isolation level. For this, before establishing connection, set the TMSConnection.IsolationLevel property to ilSnapshot.
1. A similar issue is described in the MSDN blog: http://blogs.msdn.com/b/joesack/archive ... ected=true . Try the suggestions from this article.
2. Try using Snapshot isolation level. For this, before establishing connection, set the TMSConnection.IsolationLevel property to ilSnapshot.
Re: ASYNC_NETWORK_IO
We already tried and checked the issues from the MSDN blog. I’ve just tried to use the snapshot isolation level too. This has no effect, the error still occurs.
Our current solution is to set the FetchAll property to true. But I hope for a solution in which not all data needs to transfer to the client.
Do you have any further ideas to solve this problem?
Our current solution is to set the FetchAll property to true. But I hope for a solution in which not all data needs to transfer to the client.
Do you have any further ideas to solve this problem?
Re: ASYNC_NETWORK_IO
To solve the problem, try to use the SmartFetch mode. For this, set the TMSQuery.SmartFetch.Enabled property to True.