Share via

sql drivers installed

Efff dd 536 Reputation points
2022-02-16T14:18:40.237+00:00

Hello
On one server I have both sql drivers(sqlsrv32.dll) from 2014 and SQL native client 11(SQLNCLI11.dll) from 2017
this is an older server.

On second server if i try to install the SQL native client 11(SQLNCLI11.dll) from 2017 I get a process is using a file , but I don't see it SQL native client being install .

WHY does it not show up on the second server as installed?
AND
My question is what is the difference between sql drivers and SQL native client?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,633 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,898 questions
0 comments
Accepted answer
  1. Yitzhak Khabinsky 25,846 Reputation points
    2022-02-16T15:23:51.21+00:00

    Hi @Efff dd ,

    You can check what drivers are installed by issuing the following query in SQL Server Management Studio (SSMS): 

    EXEC master.sys.sp_enum_oledb_providers;

    Here is a good link to read about Different generations of OLE DB Drivers

    Please see below.

    175022-oledb-providers.jpg

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Efff dd 536 Reputation points
    2022-02-16T18:27:09.7+00:00

    if I go to Control Panel\System and Security\Administrative Tools
    ODBC data Sources and then try to ADD it, the server lists all the available drivers on this server and i only see "SQL server" from 2014.
    but if i try to install SQL native client 11 , its cant because an application is using it.

    How can it be using something not installed?

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.