We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

MSSQL + 5.3.X ? [Answered]RSS

6 replies

Last post Aug 27, 2009 10:29 AM by Mike Ayling

  • MSSQL + 5.3.X ?

    Jul 02, 2009 06:54 AM|siiiv|LINK

    I thought it fits better to create a new thread about this. I did not find any MSSQL DLL file in the EXT folder when I unpacked the non thread safe 5.3.X. Since I do hate using crap like mySQL, I am wondering perhaps it is too soon to migrate to 5.3.X or am I missing something here?

    Is the DLL downloaded separately now or something?

     Thank you!

  • Re: MSSQL + 5.3.X ?

    Jul 02, 2009 06:14 PM|brashquido|LINK



    I do hate using crap like mySQL

    Why do you consider MySQL as crap? The vast majority of PHP driven web applications using a database backend use MySQL, and some of the busiest websites on the Internet use it. If you plan on using PHP on IIS using a variety of open source applications you are really going to struggle NOT using MySQL. 

    You can download the MSSQL driver here.

    Dominic Ryan
    Microsoft IIS MVP
    IIS Aid
    IIS and Open Source
  • Re: MSSQL + 5.3.X ?

    Jul 02, 2009 08:40 PM|siiiv|LINK

    Because it IS crap.

     anyway, so it is a separate download. hmm... another DLL to keep track of... thank you very much for the help.

  • Re: MSSQL + 5.3.X ?

    Jul 08, 2009 04:33 PM|Mike Ayling|LINK

    Unfortunately, it seems that the following is the case:

    PHP 5.3.0 no longer includes the php_mssql.dll extension.

    The SQL Server Driver for PHP 1.0 extension (php_sqlsrv.dll) will not load under PHP 5.3.0.

    The SQL Server Driver for PHP 1.1 (CTP) should work, but is not due til next month. :(


  • Re: MSSQL + 5.3.X ?

    Jul 08, 2009 10:40 PM|siiiv|LINK

    I'm using the "native" ODBC and it seems to work fine. I should also note that in case someone uses phpBB, they need alter their php.ini and have this : request_order = "GPC" instead of "GP"... some odd bug or something.

     So anyway, I got it to work now with win2k8 + php 5.3.0 + mssql2k8 AND IT'S FREAKING FAST! :DDDDDD <3


     EDIT : I love ASP.NET but sadly, there is absolutely no forum software which comes even close to phpBB so that's basically the only reason I had to install PHP. :]

  • Re: MSSQL + 5.3.X ?

    Aug 27, 2009 10:18 AM|cnavarroh|LINK

    Hi siiv, can I ask you how did you make work the sqlsrv functions, or the mssql extension? I've having some problems, like this error message:

    PHP Fatal error: Call to undefined function sqlsrv_connect() in C:\Inetpub\wwwroot\php\aw_demo.php on line 27

     Or, in the php.log file, this other:


    [27-Aug-2009 11:04:19] PHP Warning:  PHP Startup: sqlsrv: Unable to initialize module
    Module compiled with module API=20060613
    PHP    compiled with module API=20090626
    These options need to match
     in Unknown on line 0

    Did you have anyone of this problems with the extension?



  • Re: MSSQL + 5.3.X ?

    Aug 27, 2009 10:29 AM|Mike Ayling|LINK