CommandTimeout for SQL Connection string

Question

How do I configure CommandTimeout (not Connect Timeout) from connection string in SQL Server?

I thought it'd be simple to find but apparently not. Below I added CommandTimeout=60. It doesn't seem to break anything, but I have no idea if it's actually working or not (and I can't find doc on this)

Data Source=someplace.com;Initial Catalog=MyDB;CommandTimeout=60;User Id=someID;Password=secret;

it's per command. see stackoverflow.com/questions/1198951/… — muratgu
– muratgu, Commented May 28, 2019 at 18:30
muratgu thanks i read that post, but I need to figure out a way (If it exists) from connection string, not SqlCommand — user3761555
– user3761555, Commented May 28, 2019 at 18:41
@user3761555 You can see all the available properties at SqlConnectionStringBuilder Class. There is no command timeout available. Perhaps if you edit your question to explain the problem you are trying to solve we could help. — Andrew Morton
– Andrew Morton, Commented May 28, 2019 at 18:55
You CANNOT set the command timeout in the connection string. You need to specify it on the SqlCommand object at runtime — marc_s
– marc_s, Commented May 28, 2019 at 19:01
Tip: If you want to make the command timeout configurable then place it in a separate entry in the appSettings section of your config, and make the code read the timeout value from there, instead of hard-coding it into your application — ADyson
– ADyson, Commented May 28, 2019 at 19:07

flackoverstow · Accepted Answer · 2022-12-01 11:47:56Z

11

It's probably worth pointing out that setting the default command timeout via the connection string is possible in Microsoft.Data.SqlClient since version ~2.1.0. This package is the open source replacement for System.Data.SqlClient and is available from nuget

If you add e.g. ;Command Timeout=300 to your connection string and receive an error Keyword not supported: Command Timeout' you should check that you truly are using Microsoft.Data.SqlClient, and that its version is greater than 2.1; the question was posed before it was possible, but times have changed

answered Dec 1, 2022 at 11:47

flackoverstow

7666 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Peter Rosenberg · Accepted Answer · 2023-02-02 10:25:58Z

0

Confirm, using the versions of:

Microsoft ActiveX Data Objects 6.1 Library
Microsoft ActiveX Data Objects Recordset 6.0 Library

The CommandTimeout - when set for the Connection object - works also for the ADO Queries following Connection Open.

edited Feb 2, 2023 at 10:25

answered Feb 2, 2023 at 10:25

Peter Rosenberg

213 bronze badges

Collectives™ on Stack Overflow

CommandTimeout for SQL Connection string

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related