I need to install a demo of a PHP application that makes use of the SQL Server Driver for PHP. The server is an old machine that runs Windows 2000 Server SP4. I've installed the whole stack without problems:
- Apache 2.2.14
- PHP 5.3.1
- SQL Server 2005 Express Edition
- SQL Server Management Studio Express
But there's a component that's not working as expected: the SQL Server Native Client. I get an error message as soon as I call sqlsrv_connect(). I've found four different releases and none works:
If I don't install it or I install the 2005 version:
- SQLSTATE: IMSSP
- code: -49
- message: The SQL Server Driver for PHP requires the SQL Server 2008 Native Client ODBC Driver (SP1 or later) to communicate with SQL Server. That ODBC Driver is not currently installed. Access the following URL to download the SQL Server 2008 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712
If I install the 2008 version:
- SQLSTATE: IM003
- code: 160
- message: Specified driver could not be loaded due to system error 127 (SQL Server Native Client 10.0).
The system requirements for SQL Server Driver for PHP 1.1 include Windows 2000 Service Pack 4. However, the system requirements for SQL Server 2008 Native Client mentions Windows Server 2003 Service Pack 2 or greater.
Any idea?
Best Answer
I don't think that the SQL 2008 Native Client is supported on Windows 2000. Do you have a Windows 2003 system you can install this application on?