SQL 服务器的连接超时 [英] Connection timeout for SQL server

问题描述

是否可以通过修改web.config中的连接字符串来增加超时时间?

Can I increase the timeout by modifying the connection string in the web.config?

推荐答案

是的，您可以将 ;Connection Timeout=30 附加到您的 连接字符串并指定你想要的值.

Yes, you could append ;Connection Timeout=30 to your connection string and specify the value you wish.

Connection Timeout 属性中设置的超时值是以秒表示的时间.如果未设置此属性，则连接的超时值为默认值(15 秒).

The timeout value set in the Connection Timeout property is a time expressed in seconds. If this property isn't set, the timeout value for the connection is the default value (15 seconds).

此外，将超时值设置为 0，您指定您的连接尝试等待无限时间.如文档中所述，这是您不应该在连接字符串中设置的内容:

Moreover, setting the timeout value to 0, you are specifying that your attempt to connect waits an infinite time. As described in the documentation, this is something that you shouldn't set in your connection string:

0 表示没有限制，应该避免ConnectionString，因为连接尝试会无限期地等待.

A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect waits indefinitely.

这篇关于SQL 服务器的连接超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！