First, I hope my question doesn't get flagged as asking for an opinion. I have looked high and low for a definitive answer, and have yet to find one. Please give this consideration.
I have a unique opportunity to build a middle tier from scratch. Clean, brand new servers. The servers are running the current version of Ubuntu Linux. I have developed a framework of RESTful calls and now need to connect them to MS SQL Server 2012 on the back end. I have been connecting to MS SQL, with perfect success, via the FreeTDS/mssql combo for ~10 years. Perhaps that "is" the best solution?
Microsoft develops and maintains drivers for Windows, which can be sourced here:
But, when it comes to Linux, the waters muddy considerably. I know the mssql.dll library for Windows has been deprecated, but I also see people comment the mssql library for Linux and Windows are not the same thing.
So, my question is simple - what is the best maintainable, and supported, solution for connecting PHP via Linux to Microsoft SQL Server today?
Thank you in advance.