#43645 [Opn]: PHP 5.2.5 + php_mssql OR FreeTDS does not work
| From: | earnest dot berry at gmail dot com | Date: | Thu, 20 Dec 2007 18:18:39 +0000 |
| Subject: | #43645 [Opn]: PHP 5.2.5 + php_mssql OR FreeTDS does not work | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-120786@lists.php.net to get a copy of this message | ||
ID: 43645
User updated by: earnest dot berry at gmail dot com
Reported By: earnest dot berry at gmail dot com
Status: Open
Bug Type: MSSQL related
Operating System: Windows/Linux
PHP Version: 5.2.5
New Comment:
I also forgot to add that this issue has been verified by another
independent developer. He had the same issue when trying to move to
5.2.5.
Previous Comments:
------------------------------------------------------------------------
[2007-12-20 18:16:43] earnest dot berry at gmail dot com
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 this bug report at http://bugs.php.net/?id=43645&edit=1