|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-12-03 23:52 UTC] cross_phil at hotmail dot com
[2005-02-28 21:20 UTC] sniper@php.net
[2005-03-08 01:00 UTC] php-bugs at lists dot php dot net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Nov 03 18:00:01 2025 UTC |
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