WampServer

Hello. I just downloaded wamp 2.2a-x64.exe and installed it on a Win2k8 SBS machine. I'm trying to get it to work with mssql running MS SQL 2008 enterprise.


I got the server online and can see the phpinfo page and the index page, but when I enable the php extension php_mssql.dll, the server restarts and you can see its checked on the extensions menu, but you check in phpinfo and the index page and you cannot see mssql under loaded extensions.


Can someone help me figure this out? Thanks

i think mssql is gone now... if i am correct its being replaced with sqlsrv

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Yea after reading the apache error logs it looks to be true. I cannot find php_mssql.dll anywhere


I have the 2.0 and 3.0 driver downloaded and have been unable to get them to work for days now. I follow this link to perfection and still cannot get it to work: [forum.wampserver.com]

I keep getting this:



PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_sqlsrv_53_nts_vc6.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0
[Mon Dec 12 14:36:35 2011] [notice] Apache/2.2.21 (Win64) PHP/5.3.8 configured -- resuming normal operations
[Mon Dec 12 14:36:35 2011] [notice] Server built: Sep 24 2011 19:57:51
[Mon Dec 12 14:36:35 2011] [notice] Parent: Created child process 464
PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_sqlsrv_53_nts_vc6.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0
<br />
<b>Warning</b>: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_sqlsrv_53_nts_vc6.dll' - %1 is not a valid Win32 application.
in <b>Unknown</b> on line <b>0</b><br />
[Mon Dec 12 14:36:35 2011] [notice] Child 464: Child process is running
[Mon Dec 12 14:36:35 2011] [notice] Child 464: Acquired the start mutex.
[Mon Dec 12 14:36:35 2011] [notice] Child 464: Starting 64 worker threads.
[Mon Dec 12 14:36:35 2011] [notice] Child 464: Starting thread to listen on port 8080.
[Mon Dec 12 14:36:35 2011] [notice] Child 464: Starting thread to listen on port 8080.


I've tried every DLL file in the 2.0 package and in the 3.0 package



Edited 1 time(s). Last edit at 12/12/2011 08:39PM by elementalwindx.

I also just reinstalled wamp with the 32bit version, reconfigured it all, added the extensions in php.ini and added the 3.0 dlls and now I get this in the error log....

PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_sqlsrv_53_ts.dll' - The specified module could not be found.\r\n in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_pdo_sqlsrv_53_ts.dll' - The specified module could not be found.\r\n in Unknown on line 0
[Mon Dec 12 14:54:21 2011] [notice] Apache/2.2.21 (Win32) PHP/5.3.8 configured -- resuming normal operations
[Mon Dec 12 14:54:21 2011] [notice] Server built: Sep 10 2011 11:34:11
[Mon Dec 12 14:54:21 2011] [notice] Parent: Created child process 1604
PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_sqlsrv_53_ts.dll' - The specified module could not be found.\r\n in Unknown on line 0
<br />
<b>Warning</b>: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_sqlsrv_53_ts.dll' - The specified module could not be found.
in <b>Unknown</b> on line <b>0</b><br />
PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_pdo_sqlsrv_53_ts.dll' - The specified module could not be found.\r\n in Unknown on line 0
<br />
<b>Warning</b>: PHP Startup: Unable to load dynamic library 'c:/wamp_new/bin/php/php5.3.8/ext/php_pdo_sqlsrv_53_ts.dll' - The specified module could not be found.
in <b>Unknown</b> on line <b>0</b><br />
[Mon Dec 12 14:54:21 2011] [notice] Child 1604: Child process is running
[Mon Dec 12 14:54:21 2011] [notice] Child 1604: Acquired the start mutex.
[Mon Dec 12 14:54:21 2011] [notice] Child 1604: Starting 64 worker threads.
[Mon Dec 12 14:54:21 2011] [notice] Child 1604: Starting thread to listen on port 8080.
[Mon Dec 12 14:54:21 2011] [notice] Child 1604: Starting thread to listen on port 8080.



Edited 1 time(s). Last edit at 12/12/2011 08:56PM by elementalwindx.

Ok FINALLY after MANYYYY hours (3~days worth) and god knows how many different configurations I have tried. I've FINALLY made it work. OMFG.

Here I will help anyone who finds this to let them copy and paste this into their php.ini for easy trial and error:


;------------------------------2.0v6 below
;extension=php_sqlsrv_52_ts_vc6.dll
;extension=php_pdo_sqlsrv_52_ts_vc6.dll

;extension=php_sqlsrv_52_nts_vc6.dll
;extension=php_pdo_sqlsrv_52_nts_vc6.dll

;extension=php_sqlsrv_53_ts_vc6.dll
;extension=php_pdo_sqlsrv_53_ts_vc6.dll

;extension=php_sqlsrv_53_nts_vc6.dll
;extension=php_pdo_sqlsrv_53_nts_vc6.dll

;-------------------------------2.0v9 below

extension=php_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_ts_vc9.dll

;extension=php_sqlsrv_53_nts_vc9.dll
;extension=php_pdo_sqlsrv_53_nts_vc9.dll

;------------------------------3.0below
;extension=php_sqlsrv_53_ts.dll
;extension=php_pdo_sqlsrv_53_ts.dll
;extension=php_sqlsrv_53_nts.dll
;extension=php_pdo_sqlsrv_53_nts.dll
;--------------everything else


I needed to have the 32bit version of WAMP installed on Windows2008 SBS and use the ts vc9 version of the dlls to make it work. omfg what a pita this was.

well the first one I tried was nts and that did not work. (the lines below the uncommented ones. So unless you can make a miracle happen, idk how to make it work.

Oh sorry , I confused myself by recently building a nts version of wamp.

Wamp is ts

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Thank you!!

This worked for me as elementalwindx suggested:

extension=php_pdo_sqlsrv_53_ts_vc9.dll

Now if I can only get it to connect to the MSSQL server, we'd be in great shape!! :/

-Mangesh