ID: 20715
User updated by: bruno at cameleons dot net
Reported By: bruno at cameleons dot net
-Status: Feedback
+Status: Open
Bug Type: ODBC related
Operating System: Linux 2.4.19
PHP Version: 4.3.1
New Comment:
Hi,
It doesn't work.
I put below some extracts of my compile.
./configure \
--prefix=/usr \
--with-layout=GNU \
--with-apxs2=/usr/sbin/apxs \
--with-config-file-path=/etc/httpd \
--with-exec-dir=/usr/bin \
--with-ibm-db2=shared
/bin/sh /var/tmp/php4-STABLE-200303070830/libtool --silent
--preserve-dup-deps --mode=compile gcc -I/home/db2inst1/sqllib/include
-Iext/odbc/ -I/var/tmp/php4-STABLE-200303070830/ext/odbc/
-DPHP_ATOM_INC -I/var/tmp/php4-STABLE-200303070830/include
-I/var/tmp/php4-STABLE-200303070830/main
-I/var/tmp/php4-STABLE-200303070830 -I/usr/include/httpd
-I/var/tmp/php4-STABLE-200303070830/Zend
-I/var/tmp/php4-STABLE-200303070830/ext/xml/expat -D_REENTRANT
-D_SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-I/var/tmp/php4-STABLE-200303070830/TSRM -g -O2 -prefer-pic -c
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c -o
ext/odbc/php_odbc.lo
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c: In function
`safe_odbc_disconnect':
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c:199: warning:
passing arg 1 of `SQLDisconnect' makes integer from pointer without a
cast
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c:202: warning:
passing arg 1 of `SQLTransact' makes integer from pointer without a
cast
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c:202: warning:
passing arg 2 of `SQLTransact' makes integer from pointer without a
cast
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c:203: warning:
passing arg 1 of `SQLDisconnect' makes integer from pointer without a
cast
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c: In function
`_close_odbc_conn':
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c:229: warning:
passing arg 1 of `safe_odbc_disconnect' makes pointer from integer
without a cast
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c: In function
`_close_odbc_pconn':
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c:257: warning:
passing arg 1 of `safe_odbc_disconnect' makes pointer from integer
without a cast
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c: In function
`zif_odbc_data_source':
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c:1230: warning:
passing arg 2 of `odbc_sql_error' makes integer from pointer without a
cast
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c: In function
`odbc_do_connect':
/var/tmp/php4-STABLE-200303070830/ext/odbc/php_odbc.c:2223: warning:
passing arg 1 of `spprintf' from incompatible pointer type
/bin/sh /var/tmp/php4-STABLE-200303070830/libtool --silent
--preserve-dup-deps --mode=link gcc -DPHP_ATOM_INC
-I/var/tmp/php4-STABLE-200303070830/include
-I/var/tmp/php4-STABLE-200303070830/main
-I/var/tmp/php4-STABLE-200303070830 -I/usr/include/httpd
-I/var/tmp/php4-STABLE-200303070830/Zend
-I/var/tmp/php4-STABLE-200303070830/ext/xml/expat -D_REENTRANT
-D_SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-I/var/tmp/php4-STABLE-200303070830/TSRM -g -O2 -o ext/odbc/odbc.la
-export-dynamic -avoid-version -prefer-pic -module -rpath
/var/tmp/php4-STABLE-200303070830/modules -avoid-version -module
ext/odbc/php_odbc.lo
/bin/sh /var/tmp/php4-STABLE-200303070830/libtool --silent
--preserve-dup-deps --mode=install cp ext/odbc/odbc.la
/var/tmp/php4-STABLE-200303070830/modules
PATH="$PATH:/sbin" ldconfig -n
/var/tmp/php4-STABLE-200303070830/modules
[EMAIL PROTECTED] php4-STABLE-200303070830]# ldd modules/odbc.so
libc.so.6 => /lib/libc.so.6 (0x40012000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
Bruno
Previous Comments:
------------------------------------------------------------------------
[2003-03-06 22:37:29] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
Note: Try the snapshot that is generated about 2 hours
since you get this notice email. There was a typo in the
ext/odbc/config.m4 which is now fixed. It was most likely
the reason for this thing not working as shared extension.
------------------------------------------------------------------------
[2003-03-05 05:41:44] bruno at cameleons dot net
Hi,
I've the same problem with unixODBC. I've tried unixODBC shared with
php 4.2.3: it works fine.
I've compiled unixODBC static with php 4.3.1: it works fine
I've compiled IBM DB2 static with php 4.3.1: it works fine.
It seems to be a problem with odbc shared.
Bruno
------------------------------------------------------------------------
[2003-03-04 11:43:04] [EMAIL PROTECTED]
The point of ODBC is that it is cross DB compatible. It uses the same
API that DB2 does, only IBM recommends using unixODBC to interface with
DB2 rather than their own interface (which is still ODBC).
As for speed questions, this is typically irrelevent as you're still
using an ODBC-ODBC bridge which can be tuned slightly depending upon
your preferences.
------------------------------------------------------------------------
[2003-03-04 10:40:09] bruno at cameleons dot net
Ok, but is unixODBC faster or slower than DBConnect?
The syntaxe is compatible between UnixODBC and DB2connect?
I have 300 scripts PHP using odbc functions.
------------------------------------------------------------------------
[2003-03-04 10:30:33] [EMAIL PROTECTED]
please try my request
------------------------------------------------------------------------
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/20715
--
Edit this bug report at http://bugs.php.net/?id=20715&edit=1
