Query seems to hang

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 2
Joined: Wed 20 Sep 2006 18:29

Query seems to hang

Post by bernaert » Wed 20 Sep 2006 18:37


we are evaluating the corelab components for SQL Server.
We are especially interested in the fetchall = false possibility to fill the readonly grids quickly.
I've installed the trial components in bds 2006 and created a small demo application that allows me to enter a sql statement and fill up the SQL property of the query and opens the query.
Everything works fine, but the third time I try to open a query, the application seems to hang.
I don't know if this is a known issue or a limitation of the trial?

When I enter a sql statement, I do the following:


Is there maybe something else I should do to reset the query after I've used it?
Except from this problem, I must say I'm pretty impressed by this feature.

Bernaert Dominique.

Posts: 2
Joined: Wed 20 Sep 2006 18:29

Problem seems only when trying over vpn

Post by bernaert » Thu 21 Sep 2006 07:08


I've done some more testing and the problem only seems to occur when I'm trying this over a vpn connection.


Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 22 Sep 2006 14:46

Execution of query in FetchAll = False mode blocks current session.
In order to avoid blocking OLE DB creates additional session.
Probably your VPN connection limits count of simultaneous connections.
Please trace events in FetchAll = False and FetchAll = True modes using profiler.

Post Reply