Is there a CommandTimeout property on ado.net oledb

Is there a CommandTimeout property on ado.net oledb

Post by Rames » Sat, 14 Sep 2002 04:13:58



Checkout the OleDbCommand.CommandTimeout
Gets or sets the wait time before terminating an attempt to execute a
command and generating an error.
Property Value
The time (in seconds) to wait for the command to execute. The default is 30
seconds.
Remarks
A value of 0 indicates no limit, and should be avoided in a CommandTimeout
because an attempt to execute a command will wait indefinitely.

Hope this answers your question

Ramesh Thyagarajan, MCSD,MCDBA
Microsoft Developer support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

 
 
 

1. ADO 2.5/OleDB CommandTimeout ?

I need to adjust the default timeout on queries runnig under ado2.5 using
oldeb provider to SQL Server. Is the connection.commandtimeout property
supported by oldeb? Can I put this in the the connections string? Will it be
passed to the recordset?  Or must I create a command and set the timeout on
the command??

Also does ado2.5 through oledb support automatic connection pooling ???

Thanks for your help

Barry Fitzgerald

2. User Connections

3. ADO CommandTimeOut property does not work!

4. Can SqlServer run on Win95?

5. ADO CommandTimeOut property does not work

6. REGISTRY !?!?

7. Client SDK - Oledb - ADO.Net Multi-Threaded App Problems - VS.Net

8. Standby DB - ReadOnly and another DB

9. Client SDK - Oledb - ADO.Net Multi-Threaded App Problems - VS.Net 2003

10. xpath ado vs ado.net properties

11. Setting property OLEDB Provider for Oracle in ADO

12. ADO Recordset Status Property and True Grid Pro 5.0 with OLEDB Update