i am retrieving data from database then error is coming that The wait operation timed out ,please guide... i used Connect Timeout=50000,but not resolved yet
This error message doesn't always mean that there is a connection or command timeout. Often, more details about the exact cause of the issue are provided further down in the error message.
Member
116 Points
274 Posts
The wait operation timed out
Aug 31, 2019 03:09 PM|akhterr|LINK
i am retrieving data from database then error is coming that The wait operation timed out ,please guide... i used Connect Timeout=50000,but not resolved yet
regards,
akhter
All-Star
194485 Points
28078 Posts
Moderator
Re: The wait operation timed out
Aug 31, 2019 08:09 PM|Mikesdotnetting|LINK
This error message doesn't always mean that there is a connection or command timeout. Often, more details about the exact cause of the issue are provided further down in the error message.
All-Star
48510 Points
18072 Posts
Re: The wait operation timed out
Sep 01, 2019 12:13 PM|PatriceSc|LINK
Hi,
The full message could help. According to https://blogs.msdn.microsoft.com/docast/2018/10/11/connection-timeout-and-command-timeout-in-sql-server/ it could be a command timeout rather than a connection timeout.
Rather than changing https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.commandtimeout?view=netframework-4.8
it could be better to understand why your query is slow (30 seconds by default which should be enough in most cases)