RE: [PHP-DB] Problems with PHP / Progress / ODBC

2001-05-08 Thread indrek siitan 

Hi,

 Progress databases prefer the odbc_prepare, odbc_execute sequence
 over the odbc_exec functions ( I don't know why )

ok, changed the code to following:

 --- 8 ---

?
$sth=odbc_prepare($DBH,SELECT Trkoodi,Trnimi FROM Turyhma WHERE
Trkoodi103000);
if (odbc_execute($sth))
{
  while(odbc_fetch_row($sth))
  {
echo li  . odbc_result($sth,Trkoodi) .  -  .
odbc_result($sth,Trnimi);
  }
}
else
{
  echo execute failed.;
}

 --- 8 ---

still no good. odbc_execute() is successful, but the while
odbc_fetch_row() falls into infinite loop until it reaches
the PHP script max execution time. then i'll get a pageful
of lines with • - (the odbc_result() call won't return
anything)


Rgds,
  Tfr

  --== [EMAIL PROTECTED] == http://tfr.cafe.ee/ == +372-50-17621 ==--


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Problems with PHP / Progress / ODBC

2001-05-08 Thread Andrew Hill 

Hi,

You may wish to try OpenLink's ODBC drivers, available at
http://www.openlinksw.com/.
We have excellent support for Progress databases.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access  Data Integration Technology Providers

 -Original Message-
 From: indrek siitan [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, May 08, 2001 11:08 AM
 To: Mark Newnham; [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Problems with PHP / Progress / ODBC


 Hi,

  Progress databases prefer the odbc_prepare, odbc_execute sequence
  over the odbc_exec functions ( I don't know why )

 ok, changed the code to following:

  --- 8 ---

 ?
 $sth=odbc_prepare($DBH,SELECT Trkoodi,Trnimi FROM Turyhma WHERE
 Trkoodi103000);
 if (odbc_execute($sth))
 {
   while(odbc_fetch_row($sth))
   {
 echo li  . odbc_result($sth,Trkoodi) .  -  .
 odbc_result($sth,Trnimi);
   }
 }
 else
 {
   echo execute failed.;
 }

  --- 8 ---

 still no good. odbc_execute() is successful, but the while
 odbc_fetch_row() falls into infinite loop until it reaches
 the PHP script max execution time. then i'll get a pageful
 of lines with • - (the odbc_result() call won't return
 anything)


 Rgds,
   Tfr

   --== [EMAIL PROTECTED] == http://tfr.cafe.ee/ == +372-50-17621 ==--


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]