Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 27, 2012 12:40 PM by rameshram123
Member
305 Points
110 Posts
Dec 24, 2012 08:38 AM|LINK
1. How to use timeout in sql connection
2. How to use timeout in method A call method B sync?
3. How to use timeout in method A call method B Async?
Participant
1589 Points
512 Posts
Dec 24, 2012 09:04 AM|LINK
http://stackoverflow.com/questions/4308417/connection-timeout-for-sql-server
Dec 25, 2012 12:52 AM|LINK
thanks, you answer my first question.
Dec 26, 2012 05:02 AM|LINK
Please explain in details with your second and third question. And if my answer solved your first question..please mark it as an answer for others.
Dec 26, 2012 05:40 AM|LINK
question 2 & 3:
Method A call Method B, if Method B run more than 3 seconds, then Method B return NULL
Dec 26, 2012 06:24 AM|LINK
First check if what actually data is passing with your method, how large it is to fetch.
Also if you using any sessions in that methods, then specify this in your web.config,
<sessionState timeout="13600" />
775 Points
246 Posts
Dec 27, 2012 12:12 PM|LINK
Hello Jacob,
Please visit the following:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectiontimeout.aspx
I believe it will be most benefical!
Hope this helps!
Happy Reading!
Best of Luck,
With Kind Regards,
75 Points
75 Posts
Dec 27, 2012 12:40 PM|LINK
How to use timeout in sql connection
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.common.connectionsettings.connecttimeout.aspx
How to use timeout in method A call method B sync
http://stackoverflow.com/questions/3684346/call-method-b-if-method-a-is-not-called-for-more-than-n-seconds
How to use timeout in method A call method B Async
http://www.codeproject.com/Articles/37365/Calling-Method-Asynchronously-With-A-Timeout
jacobzhang
Member
305 Points
110 Posts
How to use timeout
Dec 24, 2012 08:38 AM|LINK
1. How to use timeout in sql connection
2. How to use timeout in method A call method B sync?
3. How to use timeout in method A call method B Async?
rimagandhi
Participant
1589 Points
512 Posts
Re: How to use timeout
Dec 24, 2012 09:04 AM|LINK
http://stackoverflow.com/questions/4308417/connection-timeout-for-sql-server
Regards
Rima Gandhi.
Software Developer.
jacobzhang
Member
305 Points
110 Posts
Re: How to use timeout
Dec 25, 2012 12:52 AM|LINK
thanks, you answer my first question.
rimagandhi
Participant
1589 Points
512 Posts
Re: How to use timeout
Dec 26, 2012 05:02 AM|LINK
Please explain in details with your second and third question. And if my answer solved your first question..please mark it as an answer for others.
Regards
Rima Gandhi.
Software Developer.
jacobzhang
Member
305 Points
110 Posts
Re: How to use timeout
Dec 26, 2012 05:40 AM|LINK
question 2 & 3:
Method A call Method B, if Method B run more than 3 seconds, then Method B return NULL
rimagandhi
Participant
1589 Points
512 Posts
Re: How to use timeout
Dec 26, 2012 06:24 AM|LINK
First check if what actually data is passing with your method, how large it is to fetch.
Also if you using any sessions in that methods, then specify this in your web.config,
<sessionState timeout="13600" />
Regards
Rima Gandhi.
Software Developer.
april_123456
Participant
775 Points
246 Posts
Re: How to use timeout
Dec 27, 2012 12:12 PM|LINK
Hello Jacob,
Please visit the following:
http://stackoverflow.com/questions/4308417/connection-timeout-for-sql-server
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectiontimeout.aspx
I believe it will be most benefical!
Hope this helps!
Happy Reading!
Best of Luck,
With Kind Regards,
rameshram123
Member
75 Points
75 Posts
Re: How to use timeout
Dec 27, 2012 12:40 PM|LINK
How to use timeout in sql connection
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.common.connectionsettings.connecttimeout.aspx
How to use timeout in method A call method B sync
http://stackoverflow.com/questions/3684346/call-method-b-if-method-a-is-not-called-for-more-than-n-seconds
How to use timeout in method A call method B Async
http://www.codeproject.com/Articles/37365/Calling-Method-Asynchronously-With-A-Timeout