Oledb Driver For Sql Server



Wecan get list of all registered OLEDB provider in SQL Server by using systemstored procedure:
Driver

The WDAC ODBC driver named “SQL Server” and OLE DB provider named “Microsoft OLE DB Provider for SQL Server” (SQLOLEDB) were both deprecated in favor of SQL Server Native Client when SQL Server 2005 was released for over 10 years ago. ODBC drivers from Native Client V9,10,11 and the Microsoft ODBC Driver SQL Server V11 and 13 all work in Classic ASP code interacting with SQL server (I am using SQL 2012) except for one problem - nText and Nvarchar (max).

Server
EXEC [sys].[sp_enum_oledb_providers]
Or
Oledb Driver For Sql Server


Oledb Driver For Sql Server Download

Parse Name
SQLOLEDB
Microsoft OLE DB Provider for SQL Server
{176941F9-18E8-47D6-860D-006FF2655608}
Microsoft OLE DB Provider for Analysis Services 9.0
{2CB6C2D3-DD7C-11D2-AFE4-00105A994724}
Microsoft OLE DB Provider For Data Mining Services
{397C2819-8272-4532-AD3A-FB5E43BEAA39}
Microsoft.ACE.OLEDB.12.0
Microsoft Office 12.0 Access Database Engine OLE DB Provider
{549365d0-ec26-11cf-8310-00aa00b505db}
SQLNCLI10
SQL Server Native Client 10.0
{9E175B8B-F52A-11D8-B9A5-505054503030}
MSDASQL
Microsoft OLE DB Provider for ODBC Drivers
{dee35070-506b-11cf-b1aa-00aa00b8de95}
MSDAOSP
Microsoft OLE DB Simple Provider
{e8cc4cbe-fdff-11d0-b865-00a0c9081c1d}