ID: 34852 Updated by: [EMAIL PROTECTED] Reported By: tim dot tassonis at trivadis dot com -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: Linux PHP Version: 5CVS-2005-11-03 (cvs) New Comment:
Can you repeat this error when using the PDO odbc ?? Previous Comments: ------------------------------------------------------------------------ [2005-11-30 21:09:46] [EMAIL PROTECTED] Unfortunately Dan can not be involved in this. (some license thing) ------------------------------------------------------------------------ [2005-11-04 01:49:46] [EMAIL PROTECTED] Tony: Check with Dan Scott before applying this patch; he's probably most current on this aspect of the odbc extension. ------------------------------------------------------------------------ [2005-10-13 13:34:40] tim dot tassonis at trivadis dot com Well, here is a patch. I dont know whether the formatting is preserved her properly, it should apply cleanly with "patch -p1 < patchfile" from whithing the php-5.0.5 directory. The patch just stops odbc_exec and odbc_prepare from failing if the SQLSetStmtOption fails. The warning is still displayed in the error_log. It would be great if this could be applied. So below follows the patch (created with diff -ruN): diff -ruN php-5.0.5/ext/odbc/php_odbc.c php-5.0.5-ora/ext/odbc/php_odbc.c --- php-5.0.5/ext/odbc/php_odbc.c 2005-07-03 00:50:01.000000000 +0200 +++ php-5.0.5-ora/ext/odbc/php_odbc.c 2005-10-13 12:20:55.000000000 +0200 @@ -875,9 +875,11 @@ if (SQLSetStmtOption(result->stmt, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC) == SQL_ERROR) { odbc_sql_error(conn, result->stmt, " SQLSetStmtOption"); + /* Dont fail, but go on. This can happen SQLFreeStmt(result->stmt, SQL_DROP); efree(result); RETURN_FALSE; + */ } } } else { @@ -1296,9 +1298,11 @@ if (SQLSetStmtOption(result->stmt, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC) == SQL_ERROR) { odbc_sql_error(conn, result->stmt, " SQLSetStmtOption"); + /* Dont fail, but go on. This can happen SQLFreeStmt(result->stmt, SQL_DROP); efree(result); RETURN_FALSE; + */ } } } else { ------------------------------------------------------------------------ [2005-10-13 12:14:49] tim dot tassonis at trivadis dot com Description: ------------ When using the oracle-supplied ODBC Driver under Linux, any odbc_exec() call fails with: [unixODBC][Driver Manager]Driver does not support this function The log files is a bit more verbose: [unixODBC][Driver Manager]Driver does not support this function, SQL state IM001 in SQLSetStmtOption The offending code is in odbc_prepare(line 875) and odbc_exec (line 1276), when the module tries to set SQL_CURSOR_DYNAMIC via SQLSetStmtOption, which returns an error using the oracle driver. The error goes away if I undefine HAVE_SQL_EXTENDED_FETCH, so the statements will not be reached. Would it be possible to only issue a notice when this command fails and proceed with processing. I can provide a patch to fix it, if that's appreciated. Reproduce code: --------------- $dsn="ANY_ORACLE_DSN"; $uid="ANY_VALID_USERID"; $pwd="ANY_VALID_PASSWORD"; $conn = odbc_connect ( $dsn, $uid, $pwd ); /* The connect succeeds */ if (!$conn) { printf("Error connecting to $database.<br>\n"); return; } /* The exec will fail with the decribed error */ $cursor = odbc_exec($conn,"SELECT tname from tab"); if (!$cursor) { printf("Failure in odbc_exe:<br>\n"); printf("%s<br>\n",htmlentities(odbc_errormsg($conn))); return; } Actual result: -------------- [unixODBC][Driver Manager]Driver does not support this function, SQL state IM001 in SQLSetStmtOption ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=34852&edit=1