WampServer

Hi, for my latest project I want to use SQL SERVER 2012 Express as the database. From researching on the internet I understand that I need to install some DLL drivers from Microsoft that enable PHP to talk with SQL Server. I spent several hours last night trying unsuccessfully to get this to work.

I appreciate that this is a big ask but can anyone provide a step by step guide on how I achieve this or know of a website which contains this info? Specifically I need to know which extensions I need to use as I understand that certain DLL extensions for connecting to SQL Server have now been dropped in favour of alternative ones. Also are there any configuration settings I need to change in SQL Server to enable this functionality?

Any help which can be offered on this subject will be greatly appreciated.



Edited 1 time(s). Last edit at 10/30/2013 09:28AM by stesimp.

What version of WAMPServer have you got installed?
Specifically is it 32bit or 64bit?

Apache version?
PHP Version?

Hi, thanks for the reply, I have downloaded WAMP 64 Bit with PHP 5.4 and Apache 2.4.4.

Ok as far as I know the extension you need to make PHP talk to SQL Server php_mssql is only provided as a 32but dll.

You will have to uninstall the 64bit version of WAMPServer and install the 32bit one.

That woudl explain why you cannot get the extension to work.

Ok, thanks for the advice. I will try installing a 32 bit installation of WAMP and let you know how I get on.

Hi, thanks for the advice. I can confirm that after I installed the 32 bit version of WAMP server that I was able to connect to SQL Server. I also needed to add some additional lines to my PHP.ini file as follows:

//disable these extensions by adding ; to the start of the extension

;extension=php_mssql.dll
;extension=php_pdo_mssql.dll

//then add the following extensions

extension=php_sqlsrv_54_ts.dll
extension=php_pdo_sqlsrv_54_ts.dll
extension=php5ts.dll


Thanks for your help with this.

Thanks for the feedback.

Hi, for my latest project I want to use SQL SERVER 2012 Express as the database. From researching on the internet I understand that I need to install some DLL drivers from Microsoft that enable PHP to talk with SQL Server. I spent several hours last night trying unsuccessfully to get this to work.

I appreciate that this is a big ask but can anyone provide a step by step guide on how I achieve this or know of a website which contains this info? Specifically I need to know which extensions I need to use as I understand that certain DLL extensions for connecting to SQL Server have now been dropped in favour of alternative ones. Also are there any configuration settings I need to change in SQL Server to enable this functionality?
version of WAMPServer version2.5 installed
Specifically is it 32bit

Any help which can be offered on this subject will be greatly appreciated