how about IP from the PHP server not the SQL server. hmm it happen to me
using mysql, i just wanna share hope help you
my mysql server 10.30.11.6 and my comp ip was 10.30.11.136
in mysql server i create account/user which the server not localhost but
10.30.11.136 and it worked..
i send to phpDB.. if there any result (reply).. i send to you
----- Original Message -----
From: "Jody Williams" <jodywill@xxxxxxxxx>
Cc: <php-windows@xxxxxxxxxxxxx>
Sent: Wednesday, May 09, 2007 10:36 PM
Subject: Re: [PHP-WIN] Problem With Pear::DB
> THat is what I thought. Just to confirm, I created an ODBC connection
> for the Windows 2k3 server to the Database using the Server name. I
> tried the IP in the PHP file and have the same results.
>
> Is there some kind of restriction that might be in place in Windows 2003?
>
> 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
