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)

public override string DataSource { get; }
/** @property */
public String get_DataSource ()

public override function get DataSource () : String

Not applicable.

Property Value

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 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1

Community Additions

ADD
Show:
© 2015 Microsoft