PHP version: 4.2.2
Progress Version: 9.1B27
ODBC Driver: Merant 32BIT SQL-92 3.60
Zend Optimizer version: 1.3.3
I'm having some trouble with the above specfication.
The script below (extracted from Progress Knowledge Base #21017) continues loading forever without displaying any results.
<?php
$sql="SELECT * FROM PUB.Customer";
if($conn_id=odbc_connect("sports2000","faraco","faraco",SQL_CUR_USE_DRIVER))
{
echo "connected to DSN: $dsn";
if($result=odbc_do($conn_id, $sql))
{
echo "executing '$sql'";
echo " Results: ";
odbc_result_all($result, "BGCOLOR='#AAFFAA' border=3 width=30% bordercolordark='#FF0000'");
echo "freeing result";
odbc_free_result($result);
}
else
{
echo "can not execute '$sql' ";
}
echo " closing connection $conn_id";
odbc_close($conn_id);
}
else
{
echo " can not connect to DSN: $dsn ";
}
?>