php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: cross_phil at hotmail dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Fri Jan 24 14:01:30 2025 UTC