Problem With Pear::DB
| From: | Jody Williams | Date: | Wed, 09 May 2007 14:59:48 +0000 |
| Subject: | Problem With Pear::DB | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-27858@lists.php.net to get a copy of this message | ||
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:XXXXXX@eggrs006/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:XXXXXX@eggrs006/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