Linux Journal: Making a PHP Site on Linux Work with a Microsoft SQL Server Database
Feb 17, 2003, 13:00 (22 Talkback[s])
(Other stories by David Perrin)
"A recent project at my current employer called for creating a
new web frontend to an existing MSSQL database. My boss, having
created a sophisticated MySQL and PHP-driven black diamond web site
in PHP was enthused about the prospects of further web development
with PHP. He suggested trying to get PHP on a Linux box to connect
to a MSSQL database server.
"An attempt at this task made months before ended in
frustration. This time, after nibbling away at the task for a
couple of days on a standard Red Hat system, success was had.
"Similar to Windows, one method of connecting to a MSSQL
database is through an ODBC DSN (open database connection, data
source name). The ODBC DSN specifies a MSSQL driver to make the
connection to the database. Recent versions of Red Hat include the
utility for creating the ODBC DSN, but not the driver..."