OdbcConnection.ChangeDatabase(String) Method

Reference

Definition

Namespace:: System.Data.Odbc

Assembly:: System.Data.Odbc.dll

Assembly:: System.Data.dll

Package:: System.Data.Odbc v9.0.0

Source:: OdbcConnection.cs

Source:: OdbcConnection.cs

Source:: OdbcConnection.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Changes the current database associated with an open OdbcConnection.

public:
 override void ChangeDatabase(System::String ^ value);

public:
 virtual void ChangeDatabase(System::String ^ value);

public override void ChangeDatabase (string value);

public void ChangeDatabase (string value);

override this.ChangeDatabase : string -> unit

abstract member ChangeDatabase : string -> unit
override this.ChangeDatabase : string -> unit

Public Overrides Sub ChangeDatabase (value As String)

Public Sub ChangeDatabase (value As String)

Parameters

value: String

The database name.

Implements

ChangeDatabase(String)

Exceptions

ArgumentException

The database name is not valid.

InvalidOperationException

The connection is not open.

OdbcException

Cannot change the database.

Examples

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

Private Sub CreateOdbcConnection()

    Dim connectionString As String = _
       "Driver={SQL Native Client};Server=(local);Trusted_Connection=Yes;Database=AdventureWorks;"

    Using connection As New OdbcConnection(connectionString)
        With connection
            .Open()
            Console.WriteLine("ServerVersion: " & .ServerVersion _
               & vbCrLf + "Database: " & .Database)
            .ChangeDatabase("master")
            Console.WriteLine("ServerVersion: " & .ServerVersion _
               & vbCrLf + "Database: " & .Database)
            Console.ReadLine()
        End With
    End Using
End Sub

Remarks

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.

Applies to

Jaa