Bug #9261 Updated: odbc to an oracle 'view' fails

ID: 9261 Updated by: derick Reported By: bengt.nilsson@aerotechtelub.se Old-Status: Feedback Status: Closed Bug Type: ODBC related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: No feedback Previous Comments: --------------------------------------------------------------------------- [2001-06-08 15:54:11] kalowsky@php.net from where did you remove the HAVE_SQL_EXTENDED_FETCH define? --------------------------------------------------------------------------- [2001-02-14 19:37:10] bengt.nilsson@aerotechtelub.se Hi, I disabled "#define HAVE_SQL_EXTENDED_FETCH 1 " and that seems to do the thing. /Bengt --------------------------------------------------------------------------- [2001-02-14 14:26:15] bengt.nilsson@aerotechtelub.se I've tried SQL_CUR_USE_ODBC, SQL_CUR_USE_IF_NEEDED, SQL_CUR_USE_DRIVER and SQL_CUR_DEFAULT with the same result. /Bengt --------------------------------------------------------------------------- [2001-02-14 10:19:50] kara@php.net You could try to pass SQL_CUR_USE_ODBC as additional parameter to odbc_connect() and see if this helps. --------------------------------------------------------------------------- [2001-02-14 09:54:19] bengt.nilsson@aerotechtelub.se Hi, I' running openlink to an oracle(8.1.5) server. When I try to do a 'select' from a view I get the error from PHP: "Warning: SQL error: [OpenLink][ODBC][Driver]No key columns found for table referenced by keyset driven cursor., SQL state IM909 in SQLPrepare " (Using the same driver from Perl works fine) --------------------------------------------------------------------------- The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9261&edit=2