Microsoft KB Archive/275879

Knowledge Base

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

Article ID: 275879

Article Last Modified on 4/22/2001

---

APPLIES TO

• Microsoft Visual InterDev 6.0 Standard Edition

---

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.

Keywords: kberrmsg kbprb kbctrl KB275879

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.