From: earnest dot berry at gmail dot com Operating system: Windows/Linux PHP version: 5.2.5 PHP Bug Type: MSSQL related Bug description: PHP 5.2.5 + php_mssql OR FreeTDS does not work
Description: ------------ I've tried using FreeTDS on Windows. With build 5.2.5, the php_mssql driver does not work. I haven't had a chance to investigate what changed in 5.2.5 to make this happen. I had an application running perfectly using PHP+MSSQL but upon upgrading to 5.2.5 all failed. When I down-graded, the application worked again. Also, if anyone is wondering, yes, I am using the updated ntwlib, no the default one that comes with PHP. Also, if I use the microsoft SQL Driver ( http://www.microsoft.com/sql/technologies/php/default.mspx ) using 5.2.5, I can connect to SQL Server just fine, so this leads me to believe it's a problem with 5.2.5 in particular. Also, I am not using the default port of 1433, but I have tried this connection using bot hthe default port of 1433 and the port I set to no avail. But the SQL Driver from MSFT will connect on either port, and when I downgrade it connects on either port fine. Reproduce code: --------------- $server = "localhost"; $port = "5356"; $username = 'webapp'; $password = '**********'; $db = 'drupal5'; $con = mssql_connect("$server,$port", $username, $password); if($con) { print "<h2>We have a connection!</h2>"; } else { print "<h1>NO CONNECTION TO |$server,$port| $username, $password! ERROR!</h2>"; } Expected result: ---------------- A screen that says: "We have a connection!" Actual result: -------------- A screen that says: "NO CONNECTION" with connection information. -- Edit bug report at http://bugs.php.net/?id=43645&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=43645&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=43645&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=43645&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=43645&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=43645&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=43645&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=43645&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=43645&r=needscript Try newer version: http://bugs.php.net/fix.php?id=43645&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=43645&r=support Expected behavior: http://bugs.php.net/fix.php?id=43645&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=43645&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=43645&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=43645&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=43645&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=43645&r=dst IIS Stability: http://bugs.php.net/fix.php?id=43645&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=43645&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=43645&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=43645&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=43645&r=mysqlcfg