Hi,

I am getting following error while trying to execute a Stored Procedure using Microsoft Application Blocks [Data Access Block]

"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

If I run the Stored Procedure from SQL management Studio, it takes 00:01:20 [hh:mm:ss]  but works. In my Windows application the same SP throws an exception with the above mentioned error message just after 31 seconds everytime.

 Any help, ideas on this?

 

Regards

 

Yes, the default timeout is 30s... You may try:

1. Plus "Timeout=XX" in your connection string, where XX is seconds
2. Set both Connection.ConnectionTimeout and Command.ConnectionTimeout

Hi,

 Thanks it worked!

I am surprised why we need to set both? It should be possible to use the Connection.ConnectionTimeout by Command Object. Anyway, I can run my query now.

 

Regards

Seems Connection.Timeout is limited to that specified in connection string, while Command.Timeout has nothing to do with connection... I'm also a little puzzled why ms leave us with 2 timeouts, but usually just set Command.Timeout >= Connection.Timeout it's okay~