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.
Spazio dei nomi: Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Sintassi
'Dichiarazione
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. |
Osservazioni
For more information about the OLE DB Providers, see Provider OLE DB testati con SQL Server.
Esempio
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
Piattaforme
Piattaforme di sviluppo
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.
Piattaforme di destinazione
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.