[PHP-WIN] Problem With Pear::DB

[Jody Williams]

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