ID: 34852 Comment by: hendrik dot schmieder at jedox dot com Reported By: tim dot tassonis at trivadis dot com Status: No Feedback Bug Type: ODBC related Operating System: Linux PHP Version: 5CVS-2005-11-03 (cvs) New Comment:
After compiling php against unixodbc 2.2.14 it works with Oracle ODBC driver 10.2.0.3 . Even 11.1.0.7 works now. Thanks go to <http://blog.computer-tipps.info/2008/05/> (Sorry it is in German). Previous Comments: ------------------------------------------------------------------------ [2009-08-10 13:45:20] hendrik dot schmieder at jedox dot com Still open with 5.2.10. Debian 4 Oracle ODBC driver 10.2.0.3 ------------------------------------------------------------------------ [2009-07-01 14:19:19] sebdeca at hotmail dot com I have the same issue on that case: php-4.4.9 RedHat RHEL 4 x86 php-odbc-4.3.9-3.22.12 unixodbc 2.2.11 oracle instant client 10.2.0.3 Has someone found a workaround for this? ------------------------------------------------------------------------ [2008-08-13 11:01:11] a dot zagli at comune dot scandicci dot fi dot it i have the same problem with php 4.4.9 oracle client >= 10.1 (i didn't try with versions < 10.1) i saw on msdn[1] that the function SQLSetStmtOption is deprecated starting from odbc 3.x in favor of SQLSetStmtAttr; it could be the problem. furthermore, the same pieces of code are present also in php 5.2, but i can't try to see if the error persists :-( [1]http://msdn.microsoft.com/en-us/library/ms713876(VS.85).aspx ------------------------------------------------------------------------ [2007-05-17 22:26:07] temerson at cyberitas dot com RHEL 4 (up 2 date..) PHP 4.3 (RHEL distro supplied) error: odbc_prepare(): SQL error: [unixODBC][Driver Manager]Driver does not support this function, SQL state IM001 in SQLSetStmtOption ------------------------------------------------------------------------ [2007-02-08 22:08:35] rpowell at opriver dot com Just wanted to say thinks for posting this patch. The EasySoft version which worked out of the box cost over $1,500. I just couldn't justify that expense when recompiling with this patch made the Oracle driver work. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/34852 -- Edit this bug report at http://bugs.php.net/?id=34852&edit=1
