Linux Journal: Making a PHP Site on Linux Work with a Microsoft SQL Server Database

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

• LinuxWorld: Secret Microsoft Plot to Promote Open Source Exposed!(Feb 14, 2003)
• iApplianceWeb.com: Examining Main Memory Databases(Jan 08, 2002)
• IBM developerWorks: Introduction to PHP - Finally, the perfect language for dynamic content & database interaction(Dec 25, 2000)
• PHP Tutorial: Using ADODB to port your MySQL code (Dec 17, 2000)