OdbcConnection.ChangeDatabase Method (String)

 

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
)

Parameters

value
Type: System.String

The database name.

Exception Condition
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();
	}
}

.NET Framework
Available since 1.1
Return to top
Show: