Any idea why this does work from the same server?
<?php
require_once './includes/adodb/adodb.inc.php';
$dsn = "Provider=MSDASQL;Driver={SQL
Server};SERVER=eggrs006;DATABASE=transfer_station;UID=aspj_transfer;PWD=XXXXXX;";
$db = &ADONewConnection("ado_mssql");
$db->Connect($dsn);
$rs = $db->Execute("select [name] from sysobjects");
foreach($rs as $k=>$row)
{
echo $row[0] . '<br>';
}
$db->disconnect();
?>
This is using ADOdb instead of PEAR::DB.
Jody
On 5/9/07, Stut <stuttle@xxxxxxxxx> wrote:
Jody Williams wrote:
> 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?
Can the server you're running this on resolve eggrs006 to an IP address?
If not, that's your problem. If it can then you need to check the SQL
server user to make sure it can access that database from that machine.
Note that it is very very very unlikely that this problem is anything to
do with PHP or Pear::DB.
-Stut
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
