OleDbProvider/ProviderType

[Guest]

I am retrieving table schemas for given tables; the information returns the
following items of informatin for every column in the table:

ColumnName
ColumnOrdinal
ColumnSize
NumericPrecision
NumericScale
DataType
ProviderType
IsLong
AllowDBNull
IsReadOnly
IsRowVersion
IsUnique
IsKey
IsAutoIncrement
BaseSchemaName
BaseCatalogName
BaseTableName
BaseColumnName

I am interested in ProviderType in particular. Is there a table that lists
all the possible values for this , perhaps for SQL Server & ORACLE?

Thanks.

 

[Nicholas Paldino [.NET/C# MVP]]

There can't be, as OLEDB depends on a set of interfaces that anyone can
implement, so the list of all possible values is infinite, and there is no
central registry for it. You might be able to find all local providers
installed on a machine. In order to do that, you will have to dig through
the OLEDB documentation and find out what implemented categories in the
registry the providers register themselves under.