OdbcConnection.ChangeDatabase Method (String)

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Changes the current database associated with an open OdbcConnection.

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

Public Overrides Sub ChangeDatabase (
	value As String
)

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 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

.NET Framework
Available since 1.1
Return to top
Show: