|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #30977 Can't connect in specific scenarios.
Submitted: 2004-12-03 18:03 UTC Modified: 2005-03-08 01:00 UTC
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: cross_phil at hotmail dot com Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 5.0.2 OS: win32
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2004-12-03 18:03 UTC] cross_phil at hotmail dot com
I am having trouble connecting to my MS SQL database from an external network address.  When I am at work connecting locally this code works fine.  When I am outside the building, it fails with the error mentioned in "Actual Result".  It does not appear to be a IP or a firewall issue because I can connect with the query analyser and other MS tools just fine.  Seems like some sort of network transport issue.  I can work around it using the COM example listed on the MS SQL documentation/user comments but I have libraries build around the SQL functions that I would rather use if I can figure this out.  I am mainly asking to try to determine why this function would act different in different network scenarios.

Reproduce code:
//Note: I am not disclosing my authentication for obvious reasons but my original code did have real quoted values.
mssql_connect(MY_IP, MY_UNAME, MY_PASS)
     or die('Error connecting');
echo 'success'

Expected result:

Actual result:
Warning: mssql_connect(): Unable to connect to server: in e:\\\php\dealer\test.php on line 10
Error connecting


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-12-03 23:52 UTC] cross_phil at hotmail dot com
BTW: I have tried this on 4.3.8 (my ISP) and on my laptop which is 5.0.2, so I don't think version matters.
 [2005-02-28 21:20 UTC]
Please try using this CVS snapshot:
For Windows:

 [2005-03-08 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Apr 23 21:01:31 2024 UTC