Bug #15890 Updated: MSSQL 2000 with php_mssql.dll - will not function

ID: 15890 Updated by: mike@dustsmoke.com Reported By: mike@dustsmoke.com Status: Open Bug Type: MSSQL related Operating System: Windows 2000 advanced server PHP Version: 4.1.1 New Comment: they can't be. it does not work .period. without that info thrown into the PHP.ini file. I can't fathum how many times i've seen it not work with default. Previous Comments: ------------------------------------------------------------------------ [2002-06-04 10:16:53] michael.lidgren@journalistgruppen.se Those are the default values i think. ------------------------------------------------------------------------ [2002-03-05 23:30:31] mike@dustsmoke.com OK SOMEPLACE SOMEWHERE, THERE NEEEEEEEDS to be some documentation about this. you HAVE to do it like this or it won't work and nothing out there has is; [MSSQL] extension=php_mssql.dll mssql.allow_persistent = On mssql.max_persistent = -1 mssql.max_links = -1 mssql.min_error_severity = 10 mssql.min_message_severity = 10 mssql.compatability_mode = Off I found this out outta pure accident. Throw it into some module information SOMEPLACE please for the rest of the people out there with MSSQL2000 ------------------------------------------------------------------------ [2002-03-05 18:57:43] mike@dustsmoke.com OK, php_mssql.dll will not function on a MSSQL 2000 SP2 server. I just get timeouts with the smallest SQL querys. Well I just get timouts no matter what. All I do get is the phpinfo module information that seems fine and shows everything correctly except the 7.0 part. Looking at the library information it is designed for a version 7... Now I may be wrong here, but, SQL2000 and SQL7 were entirely different engines. SQL7 was a psudo SQL engine more like an ODBC where-as SQL2000 is more of a true SQL engine more like MySQL. Config, IIS 5, PHP 4.1.1, SQL2000 SP2. (Single box) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15890&edit=1