ID: 34852 Comment by: sebdeca at hotmail 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:
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? Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2006-07-10 19:19:34] cwthomas at llu dot edu Hello, I have the same problem, but it might not be an issue with the Oracle supplied ODBC driver because I used isql (the unixODBC client) to connect to my oracle databases and it works great. I'm running RHEL 4 Update 3 with php-4.3.9-3.12, php-odbc-4.3.9-3.12, unixODBC-2.2.11-1.RHEL4.1, and the Oracle Database 10g Client Release 2 10.2.0.1.0 (not the instant client). It would be cool when this bug gets fixed to back port it so it will be included in the next EL update. ------------------------------------------------------------------------ [2006-05-17 11:03:15] david dot fuhr at web dot de same problem with orcale XE-client supplied with the free oracle XE database... $ php -v PHP 4.4.2-0.dotdeb.1 (cli) (built: Jan 13 2006 16:48:04) Copyright (c) 1997-2006 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies $ uname -a Linux pinocchio 2.6.8-2-386 #1 Tue Aug 16 12:46:35 UTC 2005 i686 GNU/Linux $ dpkg -l|grep odbc ii odbcinst1 2.2.4-11 Support library and helper program for acces ii php4-odbc 4.4.2-0.dotdeb ODBC module for php4 ii unixodbc 2.2.4-11 ODBC tools libraries ------------------------------------------------------------------------ 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
