PHP Community

Re: MSSQL + 5.3.X ?

Mike Ayling — Thu, 27 Aug 2009 14:29:30 GMT

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

Re: MSSQL + 5.3.X ?

cnavarroh — Thu, 27 Aug 2009 14:18:08 GMT

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.

Re: MSSQL + 5.3.X ?

siiiv — Thu, 09 Jul 2009 02:40:59 GMT

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. :]

Re: MSSQL + 5.3.X ?

Mike Ayling — Wed, 08 Jul 2009 20:33:35 GMT

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

Re: MSSQL + 5.3.X ?

siiiv — Fri, 03 Jul 2009 00:40:49 GMT

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 ?

brashquido — Thu, 02 Jul 2009 22:14:37 GMT

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.

MSSQL + 5.3.X ?

siiiv — Thu, 02 Jul 2009 10:54:35 GMT

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!