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?
LVL 2
detox1978Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aland CoonsSystems EngineerCommented:
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
0
detox1978Author Commented:
Yeah, that's what I read.  So why is there a 2014 driver available on the server I installed SQL 2014 on, see below

ODBC
0
Aland CoonsSystems EngineerCommented:
Same version as per link above " Microsoft ODBC Driver 11"
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

detox1978Author Commented:
That installs the 2011 driver.  There is a 2014 driver installed on the SQL server.
0
Aland CoonsSystems EngineerCommented:
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.
0
detox1978Author Commented:
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....
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
0
Aland CoonsSystems EngineerCommented:
Quote: I chatted with one of the devs about this and he said that it is not useful to compare version numbers of SQL Server Native Client with version numbers of the new ODBC driver. Even if a version of SQL Server Native Client is higher, there will be no new features in SQL Server Native Client.

Ref: http://blogs.msdn.com/b/sqlnativeclient/archive/2013/01/23/introducing-the-new-microsoft-odbc-drivers-for-sql-server.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
detox1978Author Commented:
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
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
SNAC = SQL Server Native Client
ODBC driver is different so they can't have the same name.
0
detox1978Author Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.