OracleConnection.ServerVersion Property

Reference

Definition

Namespace:: System.Data.OracleClient

Assembly:: System.Data.OracleClient.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets a string containing the version of the server to which the client is connected.

public:
 property System::String ^ ServerVersion { System::String ^ get(); };

public:
 virtual property System::String ^ ServerVersion { System::String ^ get(); };

[System.ComponentModel.Browsable(false)]
public string ServerVersion { get; }

[System.ComponentModel.Browsable(false)]
public override string ServerVersion { get; }

[<System.ComponentModel.Browsable(false)>]
member this.ServerVersion : string

Public ReadOnly Property ServerVersion As String

Public Overrides ReadOnly Property ServerVersion As String

Property Value

String

The version of the connected server.

Attributes: BrowsableAttribute

Exceptions

InvalidOperationException

The connection is closed.

Examples

The following example creates an OracleConnection and displays some of its read-only properties.

public void CreateOracleConnection()
{
    string connectionString = "Data Source=Oracle8i;Integrated Security=yes";
    using (OracleConnection connection = new OracleConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: " + connection.ServerVersion
            + "\nState: " + connection.State);
    }
}

Public Sub CreateOracleConnection()
    Dim connectionString As String = "Data Source=Oracle8i;Integrated Security=yes"
    Using connection As New OracleConnection(connectionString)
        connection.Open()
        Console.WriteLine("ServerVersion: " & connection.ServerVersion _
           + ControlChars.NewLine + "State: " & connection.State)
    End Using
End Sub

Remarks

The ServerVersion property is in Oracle version format. For example, the format for an Oracle8 release is a string in the form "8.1.7.0.0 Oracle8 Release 8.1.7.0.0 - Production."

Applies to

Dela via