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?
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.
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.
:]
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?
6 Posts
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!
387 Posts
Re: MSSQL + 5.3.X ?
Jul 02, 2009 06:14 PM|brashquido|LINK
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
6 Posts
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.
59 Posts
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.
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
6 Posts
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
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. :]
2 Posts
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?
Thanks,
Al.
59 Posts
Re: MSSQL + 5.3.X ?
Aug 27, 2009 10:29 AM|Mike Ayling|LINK
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