« Previous Next »

• 07-02-2009, 6:54 AM

  siiiv Joined on 07-02-2009, 1:33 AM Posts 6	MSSQL + 5.3.X ? Reply Contact 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!

• 07-02-2009, 6:14 PM

  In reply to

  brashquido Joined on 05-22-2006, 12:31 AM Australia Posts 339

  Re: MSSQL + 5.3.X ? Reply Contact   siiiv: 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 www.iis-aid.com My IIS articles My PHP articles My How-to guides

• 07-02-2009, 8:40 PM

  In reply to

  siiiv Joined on 07-02-2009, 1:33 AM Posts 6	Re: MSSQL + 5.3.X ? Reply Contact 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.

• 07-08-2009, 4:33 PM

  In reply to

  Mike Ayling Joined on 06-27-2006, 9:39 AM Posts 50

  Re: MSSQL + 5.3.X ? Reply Contact 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. http://social.msdn.microsoft.com/Forums/en-US/sqldriverforphp/thread/9285793e-3ddb-49be-b138-d8cdccadb635 The SQL Server Driver for PHP 1.1 (CTP) should work, but is not due til next month. :( -Mike

• 07-08-2009, 10:40 PM

  In reply to

  siiiv Joined on 07-02-2009, 1:33 AM Posts 6

  Re: MSSQL + 5.3.X ? Reply Contact 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 Thanks.  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. :]

• 08-27-2009, 10:18 AM

  In reply to

  cnavarroh Joined on 07-10-2009, 5:04 AM Chile Posts 2

  Re: MSSQL + 5.3.X ? Reply Contact 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?  Thanks,  Al.

• 08-27-2009, 10:29 AM

  In reply to

  Mike Ayling Joined on 06-27-2006, 9:39 AM Posts 50	Re: MSSQL + 5.3.X ? Reply Contact There is a new CTP of the SQL Server driver for PHP which should work with PHP 5.3 (havent tested it myself yet). Here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ccdf728b-1ea0-48a8-a84a-5052214caad9 http://blogs.msdn.com/sqlphp/archive/2009/08/18/sql-server-driver-for-php-1-1-community-technology-preview-is-now-available.aspx -Mike