Bug #13738 Updated: cant connect to external db with dns name

ID: 13738 User updated by: sliljedahl@ad-c.com Reported By: sliljedahl@ad-c.com Old Status: Feedback Status: Open Bug Type: MSSQL related Operating System: Win 2000 server PHP Version: 4.0.6 New Comment: I can ping it just fine. C:\WINDOWS>ping labdb Pinging labdb [192.168.0.63] with 32 bytes of data: Reply from 192.168.0.63: bytes=32 time=1ms TTL=128 Reply from 192.168.0.63: bytes=32 time<10ms TTL=128 Reply from 192.168.0.63: bytes=32 time<10ms TTL=128 Reply from 192.168.0.63: bytes=32 time<10ms TTL=128 Ping statistics for 192.168.0.63: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 1ms, Average = 0ms I can connect to the database using Visual Basic Apps, with either the name or the IP address, it is just the php that cant seem to resolve the name when connecting to the database. Previous Comments: ------------------------------------------------------------------------ [2001-10-19 07:36:04] sander@php.net Are you sure that your DNS is configure properly? Try to ping to labdb (just enter "ping labdb" (without the quotes) in a dos-prompt). It's likely to be a problem with your DNS-setup. ------------------------------------------------------------------------ [2001-10-18 10:56:13] sliljedahl@ad-c.com I am running php 4.0.6 on IIS 5 on a windows 2000 server My database runs ms sql 2000 on a windows 2000 server seperate machine from the web server. my dns is set so that my database machine is named labdb and its ip address in 192.168.0.63 when I execute function ConnectToDatabase() { $dbname = "is5sql"; $dbserver = "labdb"; if(!mssql_connect($dbserver, "interscale", "")){ return FALSE; } if(!mssql_select_db($dbname)){ return FALSE; } return TRUE; } I get an error that I cannot connect to the database. when i execute: function ConnectToDatabase() { $dbname = "is5sql"; $dbserver = "192.168.0.63"; if(!mssql_connect($dbserver, "interscale", "")){ return FALSE; } if(!mssql_select_db($dbname)){ return FALSE; } return TRUE; } this connects to the database and returns true. I can connect to the database server with the dns name if i use ADO, but not if i use the php_mssql.dll. can this be fixed? ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=13738&edit=1