DTSProviderType Enumeration
Describes the kind of provider that is stored.
네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
구문
‘선언
Public Enumeration DTSProviderType
public enum DTSProviderType
public enum class DTSProviderType
public enum DTSProviderType
public enum DTSProviderType
Members
Member name | Description |
---|---|
DtsDestination | The provider is a destination. |
DtsSource | The provider is a source of data. |
Odbc | The provider is an ODBC provider. |
OleDb | The provider is an OLEDB provider. |
Unknown | The 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.
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
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.