Wednesday, March 7, 2012

Connection TimeOut seems not working properly

Hi all,

I use SqlHelper to connect to database. I need to set a timeout to execute some sp because I don′t want to wait for this sp if it make me wait a lot. So I set the Connection TimeOut every time I execute a sp. But this seems not working properly. I set this value to 5 and I execute a sp than runs in 15 but It waits for it.

Any idea

Best regards

www.ITCubo.net

SqlCommands and SqlConnections both have timeout parameters. Maybe one of their values is interfering with what you want.

No comments:

Post a Comment