ID: 30977 User updated by: cross_phil at hotmail dot com Reported By: cross_phil at hotmail dot com Status: Open Bug Type: MSSQL related Operating System: win32 PHP Version: Irrelevant New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [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