Posted by "Programmer" on 10/09/70 11:28

I don't know if this will help you.

I use an openlink ODBC driver to connect to Progress via PHP like so:


$dbconn =
odbc_connect("MyDB_ODBC",$username,$password,SQL_CUR_USE_ODBC);
$strQry = "SELECT * FROM mytable WHERE mytable.field = ".$somevar;

$rsTable = odbc_do($dbconn, $strQry);

while (odbc_fetch_row($rsTable))
{
// do stuff;
}

Jeremy Schreckhise

-----Original Message-----
From: cybermalandro cybermalandro [mailto:cybermalandro@gmail.com]
Sent: Tuesday, October 04, 2005 11:48 AM
To: php-general@lists.php.net
Subject: [PHP] PROGRESS SQL_CUR_USE_ODBC

I am connecting to a PROGRESS DB through the MERANT ODBC driver, When I
have
the 4th parameter SQL_CUR_USE_ODBC as shown, my queries return nothing
but
if I have the 4th parameter as lower case it returns my query results
but
with a PHP error complainning
*Notice*: Use of undefined constant sql_cur_use_odbc - assumed
'sql_cur_use_odbc'

Wtf? I don't get it, most of the documentation from people connecting to
PROGRESS do have the 4th parameter uppercase can someone help me out ?

Thanks!

[Back to original message]