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
73 Points
185 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
191253 Points
27732 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
47020 Points
17313 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)