« Previous Next »

• 09-25-2009, 1:39 PM

  Bartsimpson Joined on 09-25-2009, 5:31 PM Posts 5

  Impossible to activate extension=php_mssql.dll Reply Contact  Hi everyone, I'm in big trouble and hopping someone will help me. I've installed php5 on Windows Server 2008, using fastCGI mode, not ISAPI. Everything runs correctly and I'm able to display a correct phpInfo in a php page. BUT, when I try to activate  php_mssql.dll removing the ";" before in php.ini file, evrything goes wrong. Evry php page, even the phpinfo one, turns into HTTP 500.0 - Internal Server Error The  extension_dir = "c:\php\ext" is correct, and the php_mssql.dll file is in. When I try to activate another extension (for exemple  mysql, it works !). HELP HELP HELP !!! :) Thanks

• 09-25-2009, 3:07 PM

  In reply to

  cstobbe Joined on 11-21-2008, 7:20 PM Edmonton, AB Posts 21	Re: Impossible to activate extension=php_mssql.dll Reply Contact  What version of PHP? If 5.3.x, it seems that php_mssql.dll is no longer supported. I believe that the recommended replacement is Microsoft's SQLSRV which you have to download separately. See http://learn.iis.net/page.aspx/246/using-fastcgi-to-host-php-applications-on-iis-70.

• 09-25-2009, 3:52 PM

  In reply to

  Bartsimpson Joined on 09-25-2009, 5:31 PM Posts 5	Re: Impossible to activate extension=php_mssql.dll Reply Contact  Well according to phpinfo, I'm using 5.2.11...

• 09-25-2009, 4:13 PM

  In reply to

  cstobbe Joined on 11-21-2008, 7:20 PM Edmonton, AB Posts 21

  Re: Impossible to activate extension=php_mssql.dll Reply Contact I see that like PHP 5.3.0, PHP 5.2.11 also does not include php_mssql.dll. I haven't tried 5.2.11, but I don't believe that it is correct to use your own php_mssql.dll from a previous PHP release. When I upgraded from 5.2.10 to 5.3.0, I had to use the SQLSRV driver instead. Unfortunately, the SQLSRV API is slightly different so I had to change some code, but it seems to work fine.

• 09-25-2009, 4:59 PM

  In reply to

  Bartsimpson Joined on 09-25-2009, 5:31 PM Posts 5	Re: Impossible to activate extension=php_mssql.dll Reply Contact Well, it's a fresh install... But I will change for SQLSRV driver. Could you give me a reliable link to see how to do that ? Thanks in advance

• 09-25-2009, 7:14 PM

  In reply to

  cstobbe Joined on 11-21-2008, 7:20 PM Edmonton, AB Posts 21	Re: Impossible to activate extension=php_mssql.dll Reply Contact You can download one of these versions of SQLSRV driver: Version 1.0 Version 1.1 CTP I'm not sure if 1.0 supports PHP 5.2.11. I know that 1.0 does not support PHP 5.3; I had to use 1.1 even though it is not yet in final release. See also: SQL Server Driver for PHP MSSQL + 5.3.X

• 09-26-2009, 4:08 AM

  In reply to

  pierrejoye Joined on 02-12-2009, 10:52 PM Germany Posts 73	Re: Impossible to activate extension=php_mssql.dll Reply Contact Be sure to have the php directory in your PATH. The MsSql extensions require a DLL, ntwdblib.dll. -- Pierre http://blog.thepimp.net | http://windows.php.net

• 09-26-2009, 9:46 AM

  In reply to

  Bartsimpson Joined on 09-25-2009, 5:31 PM Posts 5	Re: Impossible to activate extension=php_mssql.dll Reply Contact Oops... doesn't work.

• 09-26-2009, 9:55 AM

  In reply to

  Bartsimpson Joined on 09-25-2009, 5:31 PM Posts 5	Re: Impossible to activate extension=php_mssql.dll Reply Contact  Well, It finally works, I've installed SQLSRV driver... and changed my code. Thank you very much for your help.

• 11-14-2009, 4:34 AM

  In reply to

  mnq Joined on 11-14-2009, 9:32 AM Posts 2

  Re: Impossible to activate extension=php_mssql.dll Reply Contact Hey,  I got the same problem (PHP 5.2.11), php-errors shows: PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_mssql.dll' - The specified module could not be found.  And phpinfo doesn't show anything about MSSQL. I installed php_sqlsrv.dll extension and it works fine.  Can anyone tell me if I can use php_mssql.dll on PHP 5.2.11? And if yes - how?

• 11-14-2009, 1:46 PM

  In reply to

  don.raman Joined on 03-16-2009, 5:34 PM Posts 321

  Re: Impossible to activate extension=php_mssql.dll Reply Contact Hi, Can I know why do you need php_mssql.dll? php_sqlsrv.dll is the one which is fully supported by Microsoft SQL Server team and I would say if you are doing any new development you should use this DLL. php_mssql has dependency on some very old DLL which is no longer shipped as part of SQL Server nor supported by Microsoft. Please run php-cgi.exe -v from command line and it will tell you what DLL is missing? You can also use depends.exe to figure out the same. However I will say if it is possible to use php_sqlsrv.dll you should try using that. Thanks, Don.