For a new client project, I’m configuring LAMP in a way I have not before. The “M” in LAMP, often referred to as Middleware or the trademark of a certain database, is Microsoft in this case, Microsoft SQL Server.
My development workstation is running Fedora 14 and I installed the following to get it working: unixODBC, FreeTDS and php-odbc. (The other components were already installed.) In order to get it working (the target server is up and running, that’s another rant/post), I followed the how-to at http://www.unixodbc.org/doc/FreeTDS.html. Taking care to do the intermediate tests with tsql and isql, and then configuring the PHP CodeIgniter framework to use odbc (with one tweak to the source), I was up and running!
The power of Open Source continues to amaze me.