Re: [PHP-WIN] Problem With Pear::DB

2007-05-10 Thread bedul
.. if there any result (reply).. i send to you - Original Message - From: "Jody Williams" <[EMAIL PROTECTED]> Cc: 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 connectio

Re: [PHP-WIN] Problem With Pear::DB

2007-05-09 Thread Jody Williams
Any idea why this does work from the same server? Connect($dsn); $rs = $db->Execute("select [name] from sysobjects"); foreach($rs as $k=>$row) { echo $row[0] . ''; } $db->disconnect(); ?> This is using ADOdb instead of PEAR::DB. Jody On 5/9/07, Stut <[EMAIL PROTECTED]> wrote: Jody Will

Re: [PHP-WIN] Problem With Pear::DB

2007-05-09 Thread Jody Williams
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 <[EM

Re: [PHP-WIN] Problem With Pear::DB

2007-05-09 Thread Stut
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: getMessage().''.$db->getUserInfo()); } // no useful info. just trying to return something. $query = "select [name] as n from sysobj

[PHP-WIN] Problem With Pear::DB

2007-05-09 Thread 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: getMessage().''.$db->getUserInfo()); } // no useful info. just trying to return something. $query = "select [name] as n from sysobjects order by [name]";