Bug #13154: ODBC query to Openingres 2.0 fail with scs_p_GetTblAttribs: DRV_DDTables failed
| From: | andre dot felipe at embrapa dot br | Date: | Wed, 05 Sep 2001 18:57:19 +0000 |
| Subject: | Bug #13154: ODBC query to Openingres 2.0 fail with scs_p_GetTblAttribs: DRV_DDTables failed | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-65171@lists.php.net to get a copy of this message | ||
From: andre.felipe@embrapa.br
Operating system: Solaris 8
PHP version: 4.0.6
PHP Bug Type: ODBC related
Bug description: ODBC query to Openingres 2.0 fail with scs_p_GetTblAttribs: DRV_DDTables failed
No queries can be made with PHP 4 and Openlink ODBC to access OpenIngres.
Test program:
<? echo " Teste de ODBC<P>" ;
$odbc = odbc_connect("Desenv" , "notes", "notes",
SQL_CUR_USE_IF_NEEDED
);
echo " ODBC_CONNECT return code: $odbc ";
$query = "select matrica from srhtb002";
$queryprep = odbc_prepare ($odbc, $query); // This produces the error.
$result = odbc_execute($queryprep );
print "ok. result = $result";
$nextrow = odbc_fetch_row($result, 1);
if (! $nextrow ) {
print "Nco achou nada...<br>";
}
else {
print odbc_result($result , 1 );
print "<br>";
print odbc_result($result , 2 );
}
?>
The configure line is:
./configure --enable-track-vars --with-yp --with-apxs --with-oci8
--with-iodbc=/software/openlink/odbcsdk
--
Edit bug report at: http://bugs.php.net/?id=13154&edit=1