VB Application times-out (VB6, SQL7, OLEDB)
Posted on 2001-09-09
I keep getting a timeout error for a (rather large) generic query I am using.
I don't want to change the query... I'd just like to know how to tell SQL 7 / VB NOT to timeout, ever!
I have set the following in my connection string:
I have also set the EnterpriseManager->SQL Server Properties->Connections->Query Timeout Property to 120000. Note that setting it to 0 does not seem to help (in fact, the query times out faster this way)... even though it is supposed to give you unlimited time.
The query lasts for about 60 seconds before it times out.
What am I doing wrong?? Or is there a system-enforced limit to queries?
I'd prefer not to have to resort to DTS for everything I do with large tables!