This topic has not yet been rated - Rate this topic

DTSProviderSubType Enumeration

SQL Server 2008 R2

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)

Syntax

C++

JScript

public enum DTSProviderSubType

Members

	Member name	Description
	DB2	The provider is Microsoft OLE DB Provider for DB2.
	Oracle	The provider is Microsoft OLE DB Provider for Oracle. This provider supports versions up to Oracle 8.
	FlatFile	The provider is a flat file.
	DBase	The provider is dBASE.
	SqlServer	The provider is Microsoft SQL Server Native Client OLE DB Provider.
	Paradox	The provider is Corel Paradox.
	Excel	The provider is the Microsoft OLE DB Provider for Microsoft Jet 4.0.
	Access	The provider is the Microsoft OLE DB Provider for Microsoft Jet 4.0.
	None	The provider is not specified using this enumeration.

Remarks

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

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

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

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD