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

From: Date: Tue, 11 Aug 2009 14:49:17 +0000
Subject: #34852 [Com]: [PATCH] Failure in odbc_exec() using oracle-supplied odbc driver
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-140929@lists.php.net to get a copy of this message 
 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

Thread (20 messages)

« previous php.bugs (#140929) next »