Export (0) Print
Expand All

OdbcConnection.ChangeDatabase Method

Changes the current database associated with an open OdbcConnection.

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

public override void ChangeDatabase (
	string value
)
public void ChangeDatabase (
	String value
)
public override function ChangeDatabase (
	value : String
)
Not applicable.

Parameters

value

The database name.

Exception typeCondition

ArgumentException

The database name is not valid.

InvalidOperationException

The connection is not open.

OdbcException

Cannot change the database.

The value parameter must contain a valid database name, and cannot contain a null value, an empty string (""), or a string with only blank characters.

The following example creates an OdbcConnection and changes the current database.

private static 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);
        connection.ChangeDatabase("master");
        Console.WriteLine("ServerVersion: " + connection.ServerVersion
            + "\nDatabase: " + connection.Database);
        Console.ReadLine();
    }
}

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:
© 2014 Microsoft