Connect to MS SQL Server from PHP on Linux?
Solution 1
The company I work for has been running FreeTDS to connect to SQL 2000 on our production server for almost 6 years now. There's a couple of issues with special character encoding, but overall it works well.
Solution 2
Is the best free option. I've used it with Qt (C++).
You can use it with unixODBC.
If you can pay it you could use the driver from easysoft
Liam
With over 15 years experience as a Web Developer, I have gained in-depth knowledge of a wide range of web technologies. I have been responsible for the architecture of several key pieces of software for a diverse portfolio of clients, in the Photography, Education, Tourism, and Retail industries. I mostly work with PHP and JavaScript.
Updated on July 03, 2022Comments
-
Liam almost 2 years
I need to connect to an MS SQL Server database from a PHP script running on a Linux server. I'm looking at using FreeTDS as there is no official MS SQL Server driver for Linux. Is this my best option? Is it ok in a production environment? Are there other options, perhaps ODBC?
-
Liam about 15 yearsThanks, now if only I could get the connection working :)