Linux Today: Linux News On Internet Time.

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. Here's how.

"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..."

Complete Story

Related Stories: