OdbcConnection.DataSource Property

Reference

Definition

Namespace:: System.Data.Odbc

Assembly:: System.Data.Odbc.dll

Assembly:: System.Data.dll

Package:: System.Data.Odbc v9.0.2

Source:: OdbcConnection.cs

Source:: OdbcConnection.cs

Source:: OdbcConnection.cs

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 the server name or file name of the data source.

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

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

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

public string DataSource { get; }

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

member this.DataSource : string

Public Overrides ReadOnly Property DataSource As String

Public ReadOnly Property DataSource As String

Property Value

String

The server name or file name of the data source. The default value is an empty string ("") until the connection is opened.

Attributes: BrowsableAttribute

Examples

The following example creates an OdbcConnection and displays the backend data source name.

public void CreateOdbcConnection()
{
    string connectionString = "Driver={SQL Native Client};Server=(local);Trusted_Connection=Yes;Database=AdventureWorks;";

    using (OdbcConnection connection = new OdbcConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: " + connection.ServerVersion
            + "\nDatabase: " + connection.Database);

        // The connection is automatically closed at
        // the end of the Using block.
    }
}

Public Sub CreateOdbcConnection(connectionString As String)
       Using connection As New OdbcConnection(connectionString)
           With connection
               .Open()
               Console.WriteLine("ServerVersion: " & .ServerVersion _
                  & vbCrLf + "Database: " & .Database)
           End With
       End Using 
End Sub

Remarks

Retrieving the DataSource property is equivalent to calling the ODBC function SQLGetInfo with the InfoType parameter set to SQL_SERVER_NAME.

Applies to

Product	Versions
.NET	8 (package-provided), 9 (package-provided)
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7 (package-provided), 4.7, 4.7.1 (package-provided), 4.7.1, 4.7.2 (package-provided), 4.7.2, 4.8 (package-provided), 4.8, 4.8.1
.NET Standard	2.0 (package-provided)

Share via