php-windows Digest 5 Nov 2008 12:45:35 -0000 Issue 3538
Topics (messages 29073 through 29075):
PHP4 strangeness with SQL Server 2005
29073 by: Weaver Hickerson
29074 by: justin
PHP6 binary snapshot is missing dlls
29075 by: Todd Keup
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Greetings to the group. I have a PHP4 report that has a couple of queries that
"go out to lunch" when connected to 2005. Connect back to 2000 and it works
fine.
These are based on the mssql_connect, mssql_query, etc.
Any help in getting past this stumbling block would be greatly appreciated. WE
are looking to port to PHP5, but of course not overnight and this one came at
us out of left field and we already are moved to the 2005 server. Every other
php and query seems to work fine.
Is there/are there some tricks/settings for dealing with php4 and SQL Server
2005? (the web server is a separate box from the DB server, by the way..)
Thanks,
--- End Message ---
--- Begin Message ---
In my experience I haven't come across something specifically like
this. Have you run the specific query in Management Studio and taken a
look at it?
Quite often coming from a LAMP school myself, I always want to blame my
query issues on php's support of mssql but more often than not its me
looking in the wrong spot. Not to say that this is the case. Sometimes
queries running in 2000 create different execution plans than they do in
2005.
Weaver Hickerson wrote:
Greetings to the group. I have a PHP4 report that has a couple of queries that "go
out to lunch" when connected to 2005. Connect back to 2000 and it works fine.
These are based on the mssql_connect, mssql_query, etc.
Any help in getting past this stumbling block would be greatly appreciated. WE
are looking to port to PHP5, but of course not overnight and this one came at
us out of left field and we already are moved to the 2005 server. Every other
php and query seems to work fine.
Is there/are there some tricks/settings for dealing with php4 and SQL Server
2005? (the web server is a separate box from the DB server, by the way..)
Thanks,
--- End Message ---
--- Begin Message ---
I downloaded the latest Windows PHP6 (VC6) binary snapshot
http://windows.php.net/snapshots/ and installed only to discover quite a few
external dlls missing in the /ext directory. Now, I realize that some may
be changing due to internal restructure and built-in design. However, curl
is the one that triggered my Apache start failure and upon further
investigation I realized quite a few dlls were missing (I merely compared
with a binary snapshot I had pulled down back in April 2008) ...
php_curl.dll
php_dba.dll
php_dbase.dll
php_fdf.dll
php_mcrypt.dll
php_mime_magic.dll
php_ming.dll
php_oci8.dll (realize this may be changing as I reviewed the php.ini)
php_pdo.dll
php_pdo_firebird.dll
php_pdo_oci8.dll (realize this may be changing as I reviewed the php.ini)
php_pdo_oci.dll (realize this may be changing as I reviewed the php.ini)
php_pdo_sqlite.dll
php_pspell.dll
php_snmp.dll
php_zip.dll
Anybody have any insight?
--- End Message ---