Свойство WMIConn.UserName

Статья
04/26/2013

Gets or sets the user name for the connection, if you do not use Windows Authentication.

Пространство имен: Microsoft.SqlServer.Dts.ManagedConnections
Сборка: Microsoft.SqlServer.ManagedConnections (в Microsoft.SqlServer.ManagedConnections.dll)

Синтаксис

'Декларация
Public Property UserName As String 
    Get 
    Set
'Применение
Dim instance As WMIConn 
Dim value As String 

value = instance.UserName

instance.UserName = value

public string UserName { get; set; }

public:
property String^ UserName {
    String^ get ();
    void set (String^ value);
}

member UserName : string with get, set

function get UserName () : String 
function set UserName (value : String)

Значение свойства

Тип: System.String
A String that contains the user name for the connection.

Замечания

If you do not use Windows Authentication, you must provide a user name and password for the connection.

Примеры

The following code example adds a WMI connection to a package, and sets the ServerName, UserName, and Password properties. The code example needs to be modified to have the appropriate values supplied for the properties for your application.

ConnectionManager WmiConn = pkg.Connections.Add("WMI");
DtsProperty prop = WmiConn.Properties["ServerName"];
prop.SetValue(WmiConn, @"\\localhost");
WmiConn.Properties["Username"].SetValue(WmiConn, @"");
WmiConn.Properties["Password"].SetValue(WmiConn, @"");

Dim WmiConn As ConnectionManager =  pkg.Connections.Add("WMI") 
Dim prop As DtsProperty =  WmiConn.Properties("ServerName") 
prop.SetValue(WmiConn, "\\localhost")
WmiConn.Properties("Username").SetValue(WmiConn, @"")
WmiConn.Properties("Password").SetValue(WmiConn, @"")

См. также

Справочник

WMIConn Класс

Пространство имен Microsoft.SqlServer.Dts.ManagedConnections

Поделиться через