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.

Espacio de nombres: Microsoft.SqlServer.Dts.Runtime
Ensamblado: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Sintaxis

'Declaración
Public Enumeration DTSProviderSubType

public enum DTSProviderSubType

public enum class DTSProviderSubType

public enum DTSProviderSubType

public enum DTSProviderSubType

Members

Member name	Description
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 Native Client OLE DB Provider.

Notas

For more information about the OLE DB Providers, see Proveedores OLE DB probados con SQL Server.

Ejemplo

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

Plataformas

Plataformas de desarrollo

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Plataformas de destino

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Vea también

Referencia

Microsoft.SqlServer.Dts.Runtime Namespace