detox1978
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?
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?
ASKER
Same version as per link above " Microsoft ODBC Driver 11"
ASKER
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.
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.
ASKER
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....
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
MSI files are respectively for 32bit and 64bit:
ENU\x86\msodbcsql.msi
ENU\x64\msodbcsql.msi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ODBC driver is different so they can't have the same name.
ASKER
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.
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