PRB: Error "Timeout Expired" When You Use Recordset Design-Time Control (275879)


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
This article was previously published under Q275879

SYMPTOMS

When you use the Visual InterDev 6.0 Recordset Design-Time Control (DTC), and you view the Active Server Pages (ASP) page in a Web browser, you may receive the following error message:
Timeout Expired

CAUSE

This problem occurs because the Recordset DTC has its own command time-out setting, which overrides the Data Connection object's command time-out setting. The default command time-out value of the Recordset DTC is 10, and the default command time-out of Data Connection value is 30.

RESOLUTION

To work around this problem, follow these steps:
  1. Right-click the Recordset DTC, and then click Properties.
  2. On the Advanced tab, in the Command configuration section, change the Command timeout to the desired value.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Add a Data Connection to a Visual InterDev project, and point it to a database.
  2. Right-click the Data Connection, and then click Properties.
  3. On the Miscellaneous tab, in the Timeouts section, note that the command time-out is 30.
  4. Add a new ASP page to your project.
  5. Add a Recordset DTC to the ASP page. Make sure that the Connection property is set to the Data Connection that you created in step 1.
  6. Right-click the Recordset DTC, and then click Properties.
  7. On the Advanced tab, in the Command configuration section, note that the Command timeout is set to 10 by default.
  8. On the General tab, use a SQL statement or stored procedure that takes longer than 10 seconds but less than 30 seconds.For additional information on how to simulate long-running stored procedures, click the article number below to view the article in the Microsoft Knowledge Base:

    247380 HOWTO: Simulate Long-Running SQL Calls from ASP

  9. View the page in your browser. You receive the "Timeout Expired" error. The Recordset DTC's command time-out of 10 has overridden the Data Connection's command timeout of 30.
Modification Type:MajorLast Reviewed:4/22/2001
Keywords:kbCtrl kberrmsg kbprb KB275879
©2002 Microsoft Corporation. All rights reserved.