I think I have hit a dead end with my attempts to connect to a MSSQL server (2008R2) using PHP (5.4..
I am running PHP through IIS using FastCGI.
I believe I have fulfilled the prerequisites but I either get an error informing Native Client 2012 required for driver, or call to unknown function (either mssql_connect() or sqlsr_connect() depending on driver in use - MS Version 2, or 3).
- PHP is functioning correctly via IIS - phpinfo() works
- Version 3.1? SQL extensions from Microsoft are installed (added to php.ini) (php_sqlsrv_54_nts.dll && php_pdo_sqlsrv_54_nts.dll) - I have also tried the Version 2.0 DLLs, but these seem not to work at all.
- SQL Native Client installed (v 10.0)
I think the problem is that I am using Windows Server 2003 (x86) and the SQL Native Client 2012 is not supported on 2k3... I cannot install it, only 2008R2 native client, so the 5.4 drivers from MS cannot be used.
I guess I know what I think the answer is, but, can anyone tell me if what I am trying to achieve is even possible?
I assume no and that I will need to roll back to PHP 5.3 or something along those lines, I just want to confirm this prior to bursting a few more blood vessels in my eyes on this...
Any assistance will be greatly appreciated - if you need screens or more info at all, let me know