Linked Questions
11 questions linked to/from How to catch SQLServer timeout exceptions
Score of 0
2 answers
1669 views
SqlCommand.CommandTimeout is reached [duplicate]
Possible Duplicate:
How to catch SQLServer timeout exceptions
I have the following code:
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MainDll"]....
Score of 6
2 answers
12100 views
ADO/SQL Server: What is the error code for "timeout expired"?
i'm trying to trap a "timeout expired" error from ADO.
When a timeout happens, ADO returns:
Number: 0x80040E31 (DB_E_ABORTLIMITREACHED in oledberr.h)
SQLState: HYT00
NativeError: 0
...
Score of 4
1 answer
5439 views
Distinguish between SQL Server Timeout Exceptions and SqlCommand Timeout Exceptions in C#
I have read now something about SQL Server timeout exceptions. I found these two links:
how to detect sql server timeout from .NET application without using catch Exception
How to catch SQLServer ...
Score of 0
1 answer
3425 views
How to handle SQL Query CommandTimeout in C# 2.0
I have got below code in c#.
SqlConnection conn = new SqlConnection("Data Source=MANOJ-PC\\SQLEXPRESS;Initial Catalog=master;Integrated Security=False;User Id=sa;Password=Manoj;");
conn.Open();
if (...
Score of 1
3 answers
2277 views
Which one works better? Transaction in SQL Server or in C#?
I write stored procedures with read uncommitted transaction isolation level, but when connection time out the rollback in catch in SQL doesn't work.
When I use SqlTransaction in my business layer in ....
Score of 0
2 answers
3597 views
Catch Oracle timeout exceptions
I want to handle timeout exceptions differently from other SQL exceptions, much like
How to catch SQLServer timeout exceptions
However, our application supports both Oracle and MSSqlserver.
The ...
Score of 2
1 answer
2472 views
Catching a WCF Timeout Exception
I have a WCF service that invokes a potentially long running DB procedure. In the event that this causes a timeout in WCF, I want to handle this gracefully in the client.
Here is the code that I'm ...
Score of 0
1 answer
1076 views
Filtering SqlServer Command Timeout Exception for ExecReader
How do get the specific exception that has caused a sql server command to happen using the SqlException object that I have caught. I want to know when a Command timeout has occured, i.e.
try
{
// ...
Score of 2
1 answer
1365 views
How can I identify all connection related exception types in an SqlException?
I am writing a VB.net winforms application which connects to Sql server 2008. (C# answers also accepted)
I am trying to differentiate between any SqlExceptions related to the connection to the ...
Score of 0
4 answers
911 views
How to display my own exception?
I'm developing a web project where i need to add custom exception classes. For example, how can i display a message from my custom exception class when the session timeout occurs? Please help. Any ...
Score of 1
1 answer
181 views
How to tell if ADODB CommandTimeout is reached?
I have some VBA that queries a SQL database using ADODB. Currently I have the CommandTimeout set to 30 seconds. If nothing is returned, that can either be because no such record exists in the SQL ...