ID: 20715 Updated by: [EMAIL PROTECTED] Reported By: bruno at cameleons dot net -Status: Open +Status: Closed Bug Type: ODBC related Operating System: Linux 2.4.19 PHP Version: 4.3.1 New Comment:
This bug has been fixed in CVS. In case this was a PHP problem, snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. In case this was a documentation problem, the fix will show up soon at http://www.php.net/manual/. In case this was a PHP.net website problem, the change will show up on the PHP.net site and on the mirror sites in short time. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2003-03-07 04:55:05] bruno at cameleons dot net 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 ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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
