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