Cliquez pour évaluer et commenter
TechNet
Bibliothèque TechNet
SQL Server
SQL Server 2008
Integration Services
Références techniques
 DTSProviderType Enumeration
Contenu de la communauté
Dans cette section
Statistiques Annotations (0)
Réduire tout/Développer tout Réduire tout
D'autres versions sont également disponibles pour :
DTSProviderType Enumeration

Describes the kind of provider that is stored.

Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
VisualBasicDeclaration

    
CSharp

    
ManagedCPlusPlus

    
JSharp

    
JScript

    
Member nameDescription
DtsDestinationThe provider is a destination.
DtsSourceThe provider is a source of data.
OdbcThe provider is an ODBC provider.
OleDbThe provider is an OLEDB provider.
UnknownThe provider is of an unknown type.

This enumeration is used by the DBProviderInfo class, in the ProviderType property, to indicate what kind of provider the class contains.


The following example enumerates the properties of the database providers available on the computer including the DTSProviderType.

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

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez la Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Target Platforms

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server.
Contenu de la communauté   Qu'est-ce que le Contenu de la communauté ?
Ajouter du contenu RSS  Annotations
Processing
© 2009 Microsoft Corporation. Tous droits réservés. Conditions d'utilisation | Marques | Confidentialité
Page view tracker