Export (0) Print
Expand All

ConnectionSettings.ConnectTimeout Property

Gets or sets the connection time-out period in seconds.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

function get ConnectTimeout () : int 
function set ConnectTimeout (value : int)

Property Value

Type: Int32
An Int32 value that specifies the connection time-out period in seconds.

If the time taken to establish a connection with the instance of the server exceeds the connection time-out period then the connection fails.

'Connect to the local, default instance of SQL Server.
Dim srv1 As Server
srv1 = New Server()
'Modify the default database and the timeout period for the connection.
srv1.ConnectionContext.DatabaseName = "AdventureWorks2012"
srv1.ConnectionContext.ConnectTimeout = 30
'Make a second connection using a copy of the ConnectionContext property and verify settings.
Dim srv2 As Server
srv2 = New Server(srv1.ConnectionContext.Copy)
Console.WriteLine(srv2.ConnectionContext.ConnectTimeout.ToString)

Community Additions

ADD
Show:
© 2014 Microsoft