Bug #13154 Updated: ODBC query to Openingres 2.0 fail with scs_p_GetTblAttribs: DRV_DDTables failed

ID: 13154 Updated by: kalowsky@php.net Reported By: andre.felipe@embrapa.br -Status: Open +Status: Assigned Bug Type: ODBC related Operating System: Solaris 8 PHP Version: 4.0.6 Assigned To: ahill New Comment: Doing two things: 1) comment: I use OpenLink for local testing here and find that the odbc_prepare works fine with PostgreSQL ODBC, MS Access, and the Virtuoso DB. 2) Marking the status as assigned, as it's apparently been assigned to ahill. Let the email annoyances begin! Previous Comments: ------------------------------------------------------------------------ [2002-01-02 07:27:28] andre.felipe@embrapa.br Hello Lobbin, I didn't give any feedback just because I have no password to enter the system and issue my opinions. The problem is still there, I have a case opened in OpenLink SW for a long time for this matter and have sent to them every log they asked to try to help in solving the problem. This problem seems to be with Openlink driver, or else with the form that PHP 4.x uses it. I'm sure its a compatibility problem between the two. Happy new year, André Felipe ------------------------------------------------------------------------ [2001-12-28 06:10:42] lobbin@php.net No feedback. Closing. ------------------------------------------------------------------------ [2001-12-07 13:11:40] ahill@php.net We've not had any problems with your configuration - are you getting an error message? Best regards, Andrew Hill ------------------------------------------------------------------------ [2001-12-07 12:25:32] kalowsky@php.net Assigning this to Ahill as he knows the OpenLink software best. ------------------------------------------------------------------------ [2001-09-05 14:57:19] andre.felipe@embrapa.br 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 this bug report at http://bugs.php.net/?id=13154&edit=1