I have a piece of code that executes stored procedure.i have given a "Waitfor Delay '00:05' " in the SP for the purpose of testing the timeout in my C# code wherein my commandtimeout is set for 10 mins. While debugging, after 20 seconds or so when the executereader for the SP is executed,I am getting a timeout . Stuck on this for 2 days, any help is much appreciated.
1
There are 1 best solutions below
Related Questions in C#
- How to call a C language function from x86 assembly code?
- What does: "char *argv[]" mean?
- User input sanitization program, which takes a specific amount of arguments and passes the execution to a bash script
- How to crop a BMP image in half using C
- How can I get the difference in minutes between two dates and hours?
- Why will this code compile although it defines two variables with the same name?
- Compiling eBPF program in Docker fails due to missing '__u64' type
- Why can't I use the file pointer after the first read attempt fails?
- #include Header files in C with definition too
- OpenCV2 on CLion
- What is causing the store latency in this program?
- How to refer to the filepath of test data in test sourcecode?
- 9 Digit Addresses in Hexadecimal System in MacOS
- My server TCP doesn't receive messages from the client in C
- Printing the characters obtained from the array s using printf?
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in EXECUTEREADER
- how to use cellendedit in multi column datagridview with multi oledb command in vb.net
- How to use the ExecuteReaderAsync method from NReco DbDataAdapter
- How to resolve KeyNotFoundException for MySql.Data.dll in .NET 2.0 with Maria10.6 version?
- How to do select query in C# WCF service in Visual Studio and how to get the returned results?
- How do I get ExecuteReader() to efficiently add items to a List?
- how to access the data from SQL Server which is in JSON format using ASP.NET WEB API controller
- Long-time SqlCommand.ExecuteReader() stored procedure execution when sys.dm_exec_procedure_stats.max_elapsed_time is short
- Why is timeout occurring while executing a stored procedure in C# even after increasing the commandtimeout property?
- VB.NET How to use ExecuteReader well
- How to call the values of all the selections on the web page in C # asp.net
- How to change decimal separator in ExecuteReader c#
- ExecuteReaderAsync() returns some rows at first but empty seconds later
- MySQL, C# - reader.Read() gives me Null reference exception
- Given key was not present in dictionary in MySql Select statement
- Npgsql.PostgresException error on ExecuteReader when attempting to query PostgreSQL database in C# Winform
Related Questions in COMMAND-TIMEOUT
- Command Timeout parameter in postgresql connection string is not working properly in npgsql
- SQL Server command timeout: 3 options with .NET Entity Framework
- Why is timeout occurring while executing a stored procedure in C# even after increasing the commandtimeout property?
- EF Core Command Timeout Not Taking Effect
- How to support Command Time out in mysql version 5.6? I am looking for a CommandTimeout option similar to that of ADO .NET but in python
- Various difficulties creating ASP.NET Session tables via aspnet_regsql.exe
- Select query from Oracle database is not getting timeout - Connected through ADODB interop
- SqlCommand.ComandTimeout no effect
- Command timeout property in VB
- How to set command timeout for entity objectcontext
- Change CommandTimeout of SSIS OleDB Source programmatically?
- C# CommandTimeout Using statement issue
- Update command timeout to 0 in mysql db configuration
- Oracle .net Provider CommandTimeout not worked
- SQL Server log file is not available during a very long insert query
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Give ConnectionTimeout as 0, it means undefined waiting time.And one more thing , u can debug the SP using EXEC command in sql server itself and check where the time taking in code or in SP.
Connection Timout in code
Execute SP in sql server
Regards Aravind