ID: 13738
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
