ASYNC_NETWORK_IO

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ralle1
Posts: 42
Joined: Thu 27 May 2010 15:01

ASYNC_NETWORK_IO

Post by ralle1 » Mon 10 Aug 2015 09:45

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.

ralle1
Posts: 42
Joined: Thu 27 May 2010 15:01

Re: ASYNC_NETWORK_IO

Post by ralle1 » Mon 10 Aug 2015 09:52

I am using "FetchAll=False" in this Query.

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ASYNC_NETWORK_IO

Post by azyk » Wed 12 Aug 2015 11:17

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.

ralle1
Posts: 42
Joined: Thu 27 May 2010 15:01

Re: ASYNC_NETWORK_IO

Post by ralle1 » Thu 13 Aug 2015 14:43

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?

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ASYNC_NETWORK_IO

Post by azyk » Mon 17 Aug 2015 09:22

To solve the problem, try to use the SmartFetch mode. For this, set the TMSQuery.SmartFetch.Enabled property to True.

Post Reply