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
55 Points
148 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
190380 Points
27642 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
45840 Points
16687 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)