Export (0) Print
Expand All

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)

[BrowsableAttribute(false)]
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))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: " + connection.ServerVersion
            + "\nDatabase: " + connection.Database);

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

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1

Community Additions

ADD
Show:
© 2014 Microsoft