Microsoft KB Archive/275879

= PRB: Error &quot;Timeout Expired&quot; 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.



Steps to Reproduce Behavior
 Add a Data Connection to a Visual InterDev project, and point it to a database. Right-click the Data Connection, and then click Properties. On the Miscellaneous tab, in the Timeouts section, note that the command time-out is 30. Add a new ASP page to your project. 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. Right-click the Recordset DTC, and then click Properties.</li> On the Advanced tab, in the Command configuration section, note that the Command timeout is set to 10 by default.</li> 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

</li> View the page in your browser. You receive the &quot;Timeout Expired&quot; error. The Recordset DTC's command time-out of 10 has overridden the Data Connection's command timeout of 30.</li></ol>

Keywords: kberrmsg kbprb kbctrl KB275879

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.