Freigeben über

  • Artikel

ServerConnection-Konstruktor (String, String, String)

Initializes a new instance of the ServerConnection class with the specified server instance and logon credentials.

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

Syntax

'Declaration
Public Sub New ( _
    serverInstance As String, _
    userName As String, _
    password As String _
)
'Usage
Dim serverInstance As String
Dim userName As String
Dim password As String

Dim instance As New ServerConnection(serverInstance, _
    userName, password)

public ServerConnection(
    string serverInstance,
    string userName,
    string password
)

public:
ServerConnection(
    String^ serverInstance, 
    String^ userName, 
    String^ password
)

new : 
        serverInstance:string * 
        userName:string * 
        password:string -> ServerConnection

public function ServerConnection(
    serverInstance : String, 
    userName : String, 
    password : String
)

Parameter

  • serverInstance
    Typ: System. . :: . .String
    A String value that specifies the name of the instance of the server with which the connection is established.

Beispiele

'Declare a ServerConnection object variable to specify SQL authentication, login and password.
Dim conn As New ServerConnection
conn.LoginSecure = False
conn.Login = vlogin
conn.Password = vpassword
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server(conn)
'The actual connection is made when a property is retrieved.
Console.WriteLine(srv.Information.Version)
'The connection is automatically disconnected when the Server variable goes out of scope.