FIX: Data Tools Timeout Values in Visual InterDev Have No Effect

Article translations Article translations
Article ID: 224949 - View products that this article applies to.
This article was previously published under Q224949
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

SYMPTOMS

In Visual InterDev 6.0, setting the timeout values for queries run in Visual Data Tools has no effect. As a result, queries run against large data sets can timeout.

CAUSE

Visual InterDev does not pass the timeout settings in Data Tools under Options on the Tools menu to the Visual Data Tools query pane.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Visual Studio 6.0 Service Pack 3. For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:

194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed

MORE INFORMATION

These timeouts are unrelated to ADO timeout queries for an Active Server Page.

Steps to Reproduce Behavior

In Visual InterDev 6.0:
  1. On the Tools menu, click Options, then select Data Tools.
  2. Choose Data View.
  3. Change SQL query timeout to 1 second.
  4. Click OK.
  5. Connect to a large database table.
  6. Select the Data View pane, then double-click a table and execute a query that would take longer than 1 second.

Properties

Article ID: 224949 - Last Review: February 28, 2014 - Revision: 2.2
APPLIES TO
  • Microsoft Visual InterDev 6.0 Standard Edition
  • Microsoft Visual Database Tools
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbvs600sp1fix kbvs600sp2fix kbvs600sp3fix KB224949

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com