Oct 16, 2015

SQL Query to get list of all registered OLEDB provider in SQL Server

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