ID: 34852
Comment by: david dot fuhr at web dot de
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:
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
Previous Comments:
------------------------------------------------------------------------
[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 ??
------------------------------------------------------------------------
[2005-11-30 21:09:46] [EMAIL PROTECTED]
Unfortunately Dan can not be involved in this. (some license thing)
------------------------------------------------------------------------
[2005-11-04 01:49:46] [EMAIL PROTECTED]
Tony: Check with Dan Scott before applying this patch; he's probably
most current on this aspect of the odbc extension.
------------------------------------------------------------------------
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
