DataSource Property

OdbcConnection.DataSource Property


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

Namespace:   System.Data.Odbc
Assembly:  System.Data (in System.Data.dll)

public override string DataSource { get; }

Property Value

Type: System.String

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

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

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))
        Console.WriteLine("ServerVersion: " + connection.ServerVersion
            + "\nDatabase: " + connection.Database);

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

.NET Framework
Available since 1.1
Return to top
© 2015 Microsoft