共用方式為

ServerConnection Constructor (String, String, String)

  • 發行項

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

命名空間: Microsoft.SqlServer.Management.Common
組件: Microsoft.SqlServer.ConnectionInfo (in microsoft.sqlserver.connectioninfo.dll)

語法

'宣告
Public Sub New ( _
    serverInstance As String, _
    userName As String, _
    password As String _
)

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

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

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

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

參數

  • serverInstance
    A String value that specifies the name of the instance of the server with which the connection is established.
  • userName
    A String value that specifies the logon account used to establish the referenced connection.
  • password
    A String value that specifies the password used with the logon account.

備註

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

範例

'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.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

ServerConnection Class
ServerConnection Members
Microsoft.SqlServer.Management.Common Namespace

其他資源

How to: Connect to an Instance of SQL Server by Using SQL Server Authentication in Visual Basic .NET
Connecting to an Instance of SQL Server