Export (0) Print
Expand All
Expand Minimize

DTSProviderSubType Enumeration

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.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

public enum DTSProviderSubType
public enum DTSProviderSubType
public enum DTSProviderSubType

Member nameDescription
AccessThe provider is the Microsoft OLE DB Provider for Microsoft Jet 4.0.
DB2The provider is Microsoft OLE DB Provider for DB2.
DBaseThe provider is dBASE.
ExcelThe provider is the Microsoft OLE DB Provider for Microsoft Jet 4.0.
FlatFileThe provider is a flat file.
NoneThe provider is not specified using this enumeration.
OracleThe provider is Microsoft OLE DB Provider for Oracle. This provider supports versions up to Oracle 8.
ParadoxThe provider is Corel Paradox.
SqlServerThe provider is Microsoft SQL Native Client OLE DB Provider.

For more information about the OLE DB Providers, see OLE DB Providers Tested with SQL Server.


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

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

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft