RE: [PHP-DB] Problems with PHP / Progress / ODBC
| From: | Andrew Hill | Date: | Tue, 08 May 2001 15:09:22 +0000 |
| Subject: | RE: [PHP-DB] Problems with PHP / Progress / ODBC | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9176@lists.php.net to get a copy of this message | ||
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:tfr@cafe.ee]
> Sent: Tuesday, May 08, 2001 11:08 AM
> To: Mark Newnham; php-db@lists.php.net
> 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
> Trkoodi<103000");
> 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
>
> --==< tfr@cafe.ee >==< http://tfr.cafe.ee/
> >==< +372-50-17621 >==--
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>