ID: 30977 Updated by: php-bugs@lists.php.net Reported By: cross_phil at hotmail dot com -Status: Feedback +Status: No Feedback Bug Type: MSSQL related Operating System: win32 PHP Version: 5.0.2 New Comment:
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". Previous Comments: ------------------------------------------------------------------------ [2005-02-28 21:20:04] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [2004-12-03 23:52:17] 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. ------------------------------------------------------------------------ [2004-12-03 18:03:33] 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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30977&edit=1