ukerandi
asked on
The transaction has aborted. Transaction Timeout
Hi, I'm getting following error message when i'm running the stored procedure.But sometime it's working fine.
The transaction has aborted.
Transaction Timeout
The transaction has aborted.
Transaction Timeout
ASKER
I think its a timeout issue:
How to solve this.Any better coding for this or any recommendation for this
How to solve this.Any better coding for this or any recommendation for this
You haven't provided any sample of your code and what ever strategy you use to connect to SQL server...
In the connection properties you can define the Timeout.
https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectiontimeout?view=netframework-4.8
In the connection properties you can define the Timeout.
https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectiontimeout?view=netframework-4.8
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
But you really need to check the Stored Procedure...just wait for the next error...grab what you have send to SQL and check if it was OK... (just run the exact SP with the arguments you supplied on SSMS) ...maybe something is wrong.
Other than that check your network....