Bug #16782 Updated: PHP & libiodbc-3.0.5 return garbage column names with ingres

ID: 16782 Updated by: kalowsky@php.net Reported By: karlm@isd.canberra.edu.au -Status: Open +Status: Bogus Bug Type: ODBC related Operating System: Solaris 8 PHP Version: 4.2.0 New Comment: The bug system is not the appropriate forum for asking support questions. For a list of a range of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php sounds like it's an OpenLink issue. Previous Comments: ------------------------------------------------------------------------ [2002-04-24 11:04:10] ahill@php.net Please enter this into a support case at http://www.openlinksw.com/support/suppindx.htm A client-side trace would be helpful as well. Best regards, Andrew Hill ------------------------------------------------------------------------ [2002-04-23 21:23:17] karlm@isd.canberra.edu.au Use odbc_result_all or odbc_field_name to get the column names from odbc_exec call to an ingres_ii database via libiodbc-3.0.5. The resulting column names are in fact portions of the original SQL query! Referencing by column number works. I am unable to test this with another database via libiodbc, however I can reproduce it using two different ODBC drivers. Using the php native drivers to ingres does work (but is of course still experimental). Configure line below: ./configure --with-ldap=/usr/local/ --enable-libgcc --enable-ftp --with-mysql=/usr/local/mysql --with-ingres=/db/ingres --with-iodbc=/usr/local/src/libiodbc-3.0.5 --enable-discard-path --enable-wddx --enable-track-vars --enable-sysvsem --with-nsapi=/db/www/netscape/server4 --with-oci8=/oracle/home/product/8.1.7 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16782&edit=1