UserId Property (OracleConnection)

In This Topic

Gets or sets the name of the user to connect.

Syntax

Visual Basic
C#

'Declaration
 
Public Property UserId As String

public string UserId {get; set;}

Property Value

The name of the user to connect.

Remarks

When a value is assigned to this property, the OracleConnection is closed.

Leave this property blank if you want to use Integrated Security connections (OS authentication). The Password property must be empty as well.

Example

The following example creates a OracleConnection and displays the user name.

csharp

public void CreateOracleConnection()
{
  string myConnString = 
      "User Id=Scott;Password=tiger;Data Source=Ora;";
  OracleConnection myConnection = new OracleConnection(myConnString);
  myConnection.Open();
  MessageBox.Show("User: " + myConnection.UserId);
  myConnection.Close();
}

Visual Basic

Public Sub CreateOracleConnection()
  Dim myConnString As String = _
      "User Id=Scott;Password=tiger;Data Source=Ora;"
  Dim myConnection As New OracleConnection(myConnString)
  myConnection.Open()
  MessageBox.Show("User: " + myConnection.UserId)
  myConnection.Close()
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleConnection Class
OracleConnection Members
Password Property
ConnectionString Property

Send Feedback