We
can get list of all registered OLEDB provider in SQL Server by using system
stored procedure:
EXEC [sys].[sp_enum_oledb_providers]
Or
EXEC sys.xp_enum_oledb_providers
Sample output:
Provider Name
|
Parse Name
|
Provider Description
|
SQLOLEDB
|
{0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}
|
Microsoft
OLE DB Provider for SQL Server
|
MSOLAP
|
{176941F9-18E8-47D6-860D-006FF2655608}
|
Microsoft
OLE DB Provider for Analysis Services 9.0
|
MSDMine
|
{2CB6C2D3-DD7C-11D2-AFE4-00105A994724}
|
Microsoft
OLE DB Provider For Data Mining Services
|
SQLNCLI11
|
{397C2819-8272-4532-AD3A-FB5E43BEAA39}
|
SQL Server
Native Client 11.0
|
Microsoft.ACE.OLEDB.12.0
|
{3BE786A0-0366-4F5C-9434-25CF162E475E}
|
Microsoft
Office 12.0 Access Database Engine OLE DB Provider
|
ADsDSOObject
|
{549365d0-ec26-11cf-8310-00aa00b505db}
|
OLE DB
Provider for Microsoft Directory Services
|
SQLNCLI10
|
{8F4A6B68-4F36-4e3c-BE81-BC7CA4E9C45C}
|
SQL
Server Native Client 10.0
|
Search.CollatorDSO
|
{9E175B8B-F52A-11D8-B9A5-505054503030}
|
Microsoft
OLE DB Provider for Search
|
MSDASQL
|
{c8b522cb-5cf3-11ce-ade5-00aa0044773d}
|
Microsoft
OLE DB Provider for ODBC Drivers
|
Microsoft.Jet.OLEDB.4.0
|
{dee35070-506b-11cf-b1aa-00aa00b8de95}
|
Microsoft
Jet 4.0 OLE DB Provider
|
MSDAOSP
|
{dfc8bdc0-e378-11d0-9b30-0080c7e9fe95}
|
Microsoft
OLE DB Simple Provider
|
MSDAORA
|
{e8cc4cbe-fdff-11d0-b865-00a0c9081c1d}
|
Microsoft
OLE DB Provider for Oracle
|
No comments:
Post a Comment