ID: 34852 Comment by: a dot zagli at comune dot scandicci dot fi dot it 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 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 Previous Comments: ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ [2006-03-31 06:56:01] adrian dot chadd at uwa dot edu dot au 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 ------------------------------------------------------------------------ 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
