PC Review


Reply
Thread Tools Rate Thread

Command Time Out when executing stored procedures VIA Data Access

 
 
=?Utf-8?B?TUtub3Ro?=
Guest
Posts: n/a
 
      3rd Feb 2005
I am using the Microsoft Data Access Application Block for .NET v2 to run
stored procedures with the ExecuteDataset, ExecuteScaler and ExecuteReader
functions. Some of my stored procedures take longer than 30 seconds to run
and I am getting time out errors in my application.

Why was the ability to specify a command time out not part of this class? Is
this in version 3 of the block? What would be the best way to add the ability
to set the CommandTimeOut for this class?

Thanks,

Matthew

 
Reply With Quote
 
 
 
 
W.G. Ryan eMVP
Guest
Posts: n/a
 
      4th Feb 2005
Add a property to the application block or just add an augmented method.
You have the code so you can do with it as you please. We have tons of
augmentation we've done with it to fit out needs - that's the nice part of
having the code. You can do it internally or use a config setting or just
add some new overloads to it.

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"MKnoth" <(E-Mail Removed)> wrote in message
news:1847095F-E7DE-4C68-B374-(E-Mail Removed)...
> I am using the Microsoft Data Access Application Block for .NET v2 to run
> stored procedures with the ExecuteDataset, ExecuteScaler and

ExecuteReader
> functions. Some of my stored procedures take longer than 30 seconds to run
> and I am getting time out errors in my application.
>
> Why was the ability to specify a command time out not part of this class?

Is
> this in version 3 of the block? What would be the best way to add the

ability
> to set the CommandTimeOut for this class?
>
> Thanks,
>
> Matthew
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Executing SQL Server Stored Procedures using ODBC.NET Stuart Ferguson Microsoft C# .NET 4 7th Jan 2005 01:44 PM
Executing Stored Procedures Nexus Microsoft Access ADP SQL Server 2 17th Sep 2004 10:22 PM
Error: Executing Stored Procedures-- Cannot Pass TimeStamp Values From sqlCommand Object Parameter to A SQL Stored Procedure =?Utf-8?B?VGVjaE1E?= Microsoft ADO .NET 3 17th Mar 2004 04:03 AM
Executing Master Stored Procedures Jim Heavey Microsoft ADO .NET 2 16th Dec 2003 07:58 PM
Executing stored procedures Andy Williams Microsoft Access ADP SQL Server 2 7th Nov 2003 02:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:01 PM.