For some time now I’ve been looking for a solution for projects that are using PHP but are connecting to a remote Microsoft SQL Server database.
As many already know, the webmasters ideal (or at least mine) is a LAMP stack which, for those that are not sure, is Linux, Apache, MySQL and PHP. Why is that an ideal, you ask, well have you ever tried getting PHP interacting with a MS SQL database? Enough said.
In short doing the above is definitely not straightforward, even on a Windows platform, where you’ll most likely be transferring and copying .DLL’s from one system folder to another and editing .INI files left, right and centre. (More …)