#34852 [Com]: [PATCH] Failure in odbc_exec() using oracle-supplied odbc driver

 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