I have a linux webserver that requires grabbing data from a windows sql server. Now I read that before the linux server connects to the sql server it must have microsofts OCDB sql driver installed. Now I have am having issues trying to get the driver installed on the webserver. Can anyone point me in the right direction or to an up to date article on how to install the OCDB sql driver? Is it just better to migrate the website to a windows plateform?
The resources I have found have been unhelpful and the files provided do not even work.
Machine Details: Debian 8.xx running on VMware.
I get the driver from here label Redhat/6 driver
https://www.microsoft.com/en-us/download/details.aspx?id=36437
they also have odbc version 1.0
https://www.microsoft.com/en-US/Download/details.aspx?id=28160
And Microsoft's walkthrough is here.
https://technet.microsoft.com/en-us/library/hh568454(v=sql.110).aspx
Now searching through the internet, tutorials use the redhat driver above loaded onto various linux machines. The Problem comes in, is that I have to go out of my way to get the file fixes. Found here https://github.com/Andrewpk/Microsoft--SQL-Server--ODBC-Driver-1.0-for-Linux-Fixed-Install-Scripts. I feel that if this is the case I might as well find an entire new solution to the problem.