OdbcConnection.DataSource Property

Definition

Namespace:

System.Data.Odbc

Assembly:

System.Data.Odbc.dll

Package:

System.Data.Odbc v8.0.0

Source:

OdbcConnection.cs

Gets the server name or file name of the data source.

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

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

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

Public Overrides 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.

See also

• Connecting to Data Sources