ID: 34852
Comment by: rpowell at opriver 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:
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.
Previous Comments:
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
[2005-12-20 01:00:05] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2005-12-12 10:31:21] [EMAIL PROTECTED]
Can you repeat this error when using the PDO odbc ??
------------------------------------------------------------------------
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
