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

> -----Original Message-----
> From: indrek siitan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 11:38 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP-DB] Problems with PHP / Progress / ODBC
> 
> 
> Hi,
> 
> I'm trying to write a PHP app that accesses a Progress database.
> 
> version info:
>  - Windows 2000 Pro + Apache 1.3.14
>  - PHP 4.0.4pl1 (4.0.5 just wouldn't work on my machine)
>  - Progress 8.3.B
>  - Merant Progress ODBC drivers v 3.50
> 
> the ODBC drivers seem to be fine - I made a MS Access database
> and linked a bunch of Progress tables in there with Get External
> Data / Link tables. I can view/query them just fine.
> 
> now, I tried a simple PHP app:
> 
>  --- 8< ---
> 
> <?
>   $DBH=odbc_connect("mgauto","","","");
>   $sth=odbc_exec($DBH,"SELECT Trkoodi,Trnimi FROM Turyhma"); 
>   while(odbc_fetch_row($sth))
>   {
>     echo "<li> ".odbc_result($sth,"Trkoodi")." - 
> ".odbc_result($sth,"Trnimi");
>   }
>   odbc_close($DBH);
> ?>
> 
>  --- 8< ---
> 
> The odbc_exec() query seems to be fine (when i do "echo $sth" after
> the exec, i get "Resource id #2"). but the odbc_fetch_row() really
> acts weird - it always returns true so it ends up in endless loop.
> the odbc_result() calls return empty strings.
> 
> I've tried the odbc_connect() with all the possible cursor types,
> doesn't help.
> 
> I've tried something like that:
> 
>  --- 8< ---
> 
> $i=1;
> while(1)
>  {
>   if (!odbc_fetch_row($sth,$i)) break;
>   echo "<li> ".odbc_result($sth,"Trkoodi")." - 
> ".odbc_result($sth,"Trnimi");
>   $i++;
>  }
> 
>  --- 8< ---
> 
> didn't work either. :(
> 
> 
> as a really stoopid thing, I tried creating an ODBC source for the
> Access database I created before (with the Progress tables linked
> in via ODBC). now I connected to the Access database via ODBC in
> PHP and tried to query the Progress tables linked into the Access.
> everything worked fine - I could access all the information in
> Progress.
> 
> 
> any other ideas?
> 
> 
> 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]

Reply via email to