Bug #13738 Updated: cant connect to external db with dns name
| From: | sander@php.net | Date: | Fri, 19 Oct 2001 11:36:04 +0000 |
| Subject: | Bug #13738 Updated: cant connect to external db with dns name | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-68355@lists.php.net to get a copy of this message | ||
ID: 13738
Updated by: sander
Reported By: sliljedahl@ad-c.com
Old Status: Open
Status: Feedback
Bug Type: MSSQL related
Operating System: Win 2000 server
PHP Version: 4.0.6
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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