|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2005-10-13 12:14 UTC] 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
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 23 08:01:28 2024 UTC |
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 {We're having the same problem: matrix:~# php5 -v PHP 5.1.2-1 (cli) (built: Jan 18 2006 06:49:47) Copyright (c) 1997-2006 The PHP Group Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies matrix:~# cat adri.php5 <?php $connect = odbc_connect(auth and db stuff goes here); $result = @odbc_data_source($connect, SQL_FETCH_FIRST); while ($result) { print "result:\n"; print_r($result); print "\n"; $result = @odbc_data_source($connect, SQL_FETCH_NEXT); } $res = odbc_prepare($connect, "SELECT * FROM FOO"); odbc_close($connect); ?> matrix:~# php5 adri.php5 result: Array ( [server] => HISDEV [description] => OracleODBC-10g ) Warning: odbc_prepare(): SQL error: [unixODBC][Driver Manager]Driver does not support this function, SQL state IM001 in SQLSetStmtOption in /root/adri.php5 on line 12 matrix:~# dpkg -l | grep odbc rc odbcinst1 2.2.4-11 Support library and helper program for acces ii odbcinst1debia 2.2.11-10 Support library and helper program for acces ii php5-odbc 5.1.2-1 ODBC module for php5 ii unixodbc 2.2.11-10 ODBC tools libraries Can someone shed some light on this? What can/should I try? adrian