|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2001-10-18 10:56 UTC] sliljedahl at ad-c dot 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?
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Fri Apr 19 06:01:29 2024 UTC |
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.