OleDbConnection.Provider Property

Definition

Namespace:

System.Data.OleDb

Assembly:

System.Data.OleDb.dll

Package:

System.Data.OleDb v9.0.0

Source:

OleDbConnection.cs

Gets the name of the OLE DB provider specified in the "Provider= " clause of the connection string.

public:
 property System::String ^ Provider { System::String ^ get(); };

[System.ComponentModel.Browsable(true)]
public string Provider { get; }

[<System.ComponentModel.Browsable(true)>]
member this.Provider : string

Public ReadOnly Property Provider As String

Property Value

String

The name of the provider as specified in the "Provider= " clause of the connection string. The default value is an empty string.

Attributes

BrowsableAttribute

Examples

The following example creates an OleDbConnection and displays some of its read-only properties.

static void OpenConnection(string connectionString)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        try
        {
            connection.Open();
            Console.WriteLine("ServerVersion: {0} \nProvider: {1}",
                connection.ServerVersion, connection.Provider);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }
}

Public Sub OpenConnection(ByVal connectionString As String)

    Using connection As New OleDbConnection(connectionString)
        Try
            connection.Open()
            Console.WriteLine("ServerVersion: {0} Provider: {1}", _
                connection.ServerVersion, connection.Provider)
        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
        ' The connection is automatically closed when the
        ' code exits the Using block.
    End Using
End Sub

See also

• Connecting to Data Sources