Link to home
Start Free TrialLog in
Avatar of detox1978
detox1978Flag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL 2014 ODBC driver

Hi All,

How do I install the SQL 2014 ODBC driver?

I noticed there is a 2014 version available on a server I installed SQL 2014.  However when I installed latest ODBC SQL driver from Microsoft its not included.



Any ideas how I can install the 2014 ODBC driver?
Avatar of Aland Coons
Aland Coons
Flag of United States of America image

Link:
https://msdn.microsoft.com/en-us/library/JJ730314(v=SQL.110).aspx

This is Microsoft ODBC Driver 11 for SQL Server on Windows (SQL Server 2012)

There is no SQL Server 2014 Native Client. There will be no more updates to the ODBC driver.

Ref.
https://msdn.microsoft.com/en-us/library/cc280510.aspx
Avatar of detox1978

ASKER

Yeah, that's what I read.  So why is there a 2014 driver available on the server I installed SQL 2014 on, see below

User generated image
Same version as per link above " Microsoft ODBC Driver 11"
That installs the 2011 driver.  There is a 2014 driver installed on the SQL server.
If you look at your screen shot it clearly reads ODBC Driver 11.
I understand that was installed with SQL 2014?

When you install the driver in the link provided on a workstation does it appear any differently?  Can you provide comparative screen shots if it is different because the download link reads "ODBC Driver 11" so I assume it's a match for the one installed with SQL 2014.
The screenshot is from a server after I install the driver in your link.

https://www.microsoft.com/en-us/download/details.aspx?id=36434

It's the 2011 not 2014....
You need to download the last ODBC 11 for SQL Server from the SQL Server 2014 Feature Pack SP1.
MSI files are respectively for 32bit and 64bit:
ENU\x86\msodbcsql.msi
ENU\x64\msodbcsql.msi
ASKER CERTIFIED SOLUTION
Avatar of Aland Coons
Aland Coons
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'm not sure what you mean by native vs odbc driver.  They both have the same name, however one is 2011 and the other is 2014
SNAC = SQL Server Native Client
ODBC driver is different so they can't have the same name.
Thanks for the info.  It does seem alarming Microsoft would release a newer driver with the server install, but not allow people to download it.  maybe it's my OCD wanting to keep everything on the same DLL version.