php.net |  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
Votes:1
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
Description:
------------
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:
---------------
<?php
//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:
----------------
success

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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

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] sniper@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip


 [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-2022 The PHP Group
All rights reserved.
Last updated: Wed Dec 07 00:03:19 2022 UTC