Query seems to hang

[bernaert]

Hello,

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:

Query.Close;
Query.SQL.Clear;
Query.SQL.Add(Edit1.Text);
Query.Open;

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.

Thx,
Bernaert Dominique.

[bernaert]

Hello,

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

Dominique.

[Jackson]

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.