DTSProviderSubType DTSProviderSubType DTSProviderSubType DTSProviderSubType Enum

Definition

Identifies a specific OLE DB provider. The enumeration value also identifies the data type format used by that provider when the ProviderType is OLE DB.

public enum class DTSProviderSubType
public enum DTSProviderSubType
type DTSProviderSubType = 
Public Enum DTSProviderSubType
Inheritance
DTSProviderSubTypeDTSProviderSubTypeDTSProviderSubTypeDTSProviderSubType

Fields

Access Access Access Access -1

The provider is the Microsoft OLE DB Provider for Microsoft Jet 4.0.

AzBlob AzBlob AzBlob AzBlob -9
DB2 DB2 DB2 DB2 -8

The provider is Microsoft OLE DB Provider for DB2.

DBase DBase DBase DBase -5

The provider is dBASE.

Excel Excel Excel Excel -2

The provider is the Microsoft OLE DB Provider for Microsoft Jet 4.0.

FlatFile FlatFile FlatFile FlatFile -6

The provider is a flat file.

None None None None 0

The provider is not specified using this enumeration.

Oracle Oracle Oracle Oracle -7

The provider is Microsoft OLE DB Provider for Oracle. This provider supports versions up to Oracle 8.

Paradox Paradox Paradox Paradox -3

The provider is Corel Paradox.

SqlServer SqlServer SqlServer SqlServer -4

The provider is Microsoft SQL Server Native Client OLE DB Provider.

Examples

This enumeration is used by the DBProviderInfo class in the ProviderSubType property. The following example enumerates the properties of the database providers available on the computer, including the ProviderSubType which returns a value from this enumeration.

namespace dbproviderinfo  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            DBProviderInfos dbis = app.DBProviderInfos;  
            foreach (DBProviderInfo dbi in dbis)  
            {  
                Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName);  
                Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType);  
                Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName);  
            }  
        }  
    }  
}  
Namespace dbproviderinfo  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim app As Application =  New Application()   
            Dim dbis As DBProviderInfos =  app.DBProviderInfos   
            Dim dbi As DBProviderInfo  
            For Each dbi In dbis  
                Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName)  
                Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType)  
                Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName)  
            Next  
        End Sub  
    End Class  
End Namespace  

Sample output:

Description = MediaCatalogDB OLE DB Provider, Name = MediaCatalogDB OLE DB Provider, ParseName = {09E767A6-4481-4791-86A5-A739E5290E4C}

ProviderSubType =None, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Description = Microsoft OLE DB Provider for SQL Server, Name = SQLOLEDB, ParseName = {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}

ProviderSubType =SqlServer, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Applies to