Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

DTSProviderSubType Enumeration

 

Applies To: SQL Server 2016 Preview

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

Member nameDescription
Access

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

DB2

The provider is Microsoft OLE DB Provider for DB2.

DBase

The provider is dBASE.

Excel

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

FlatFile

The provider is a flat file.

None

The provider is not specified using this enumeration.

Oracle

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

Paradox

The provider is Corel Paradox.

SqlServer

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

Legacy Code Example

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

Return to top

Community Additions

Show:
© 2015 Microsoft