I have a situation where I am unable to connect to a Microsoft SQL
2005 Database from Windows Server 2003 (IIS + PHP 5.0.4).
here is the code:
<?php
require_once 'DB.php';
$dsn = "mssql://aspj_transfer:[EMAIL PROTECTED]/transfer_station";
$db = DB::connect($dsn);
if (DB::isError($db))
{
die ($db->getMessage().'<br>'.$db->getUserInfo());
}
// no useful info. just trying to return something.
$query = "select [name] as n from sysobjects order by [name]";
$data =& $db->query($query);
while ($row = $data->fetchRow())
{
echo $row[0]."<br>";
}
$db->disconnect();
?>
Here is the error:
[DB Error: connect failed] **
mssql://aspj_transfer:[EMAIL PROTECTED]/transfer_station
From my workstation, this can connect just fine (Windows XP, IIS, PHP 5.0.4).
There aren't any firewalls between the machines.
Any suggestions?
Jody
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
