ID: 8920 Updated by: kalowsky Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: as per user request Previous Comments: --------------------------------------------------------------------------- [2001-02-02 21:49:55] [EMAIL PROTECTED] I discovered that this is a problem specific to the FreeTDS 0.51 library and it does not occur when using the Sybase-ct library. Please remove this from the "active" list. --------------------------------------------------------------------------- [2001-01-25 18:22:09] [EMAIL PROTECTED] This works fine when retrieving only "small" fields, BLOB fields cause problems. I've tried it on a different system with the same RPM install and the results are identical. It only fails on a BLOB retrieval from MS SQL server (we don't have anything other than MS SQL & My SQL Server to test with). ------------------------ <html> <?php $conn = mssql_connect ("x.x.x.x", "uu", "pp"); mssql_select_db ( "Metro", $conn ); $result = mssql_query ( "SELECT * FROM Materials", $conn ); print "Hello : " . $result; ?> </html> ------------------------ The MySQL version of this script works fine when accessing a BLOB field. ------------------------ Configure Command './configure' '--prefix=/usr' '--with-apxs' '--libdir=/usr/lib/php4' '--includedir=/usr/include' '--datadir=/usr/share/php' '--with-config-file-path=/etc' '--enable-inline-optimization' '--enable-magic-quotes' '--enable-track-vars' '--enable-memory-limit' '--enable-wddx' '--enable-bcmath' '--enable-sigchild' '--with-xml' '--with-mm' '--enable-ftp=shared' '--with-gd=shared' '--with-ttf' '--enable-gd-imgstrttf' '--with-png-dir=/usr' '--with-jpeg-dir=/usr' '--enable-sysvsem=shared' '--enable-sysvshm=shared' '--enable-shmop=shared' '--with-unixODBC=shared' '--with-mysql=shared' '--with-ldap=shared' '--with-imap=shared' '--with-imap-ssl=shared' '--with-pgsql=shared' '--with-gettext=shared' '--with-pspell=shared' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-sybase-ct=shared,/usr/freetds' '--with-pdflib=shared' '--with-oci8=shared' '--with-swf=shared,/home/troels/rpm/BUILD/php-4.0.4pl1/swflib' '--enable-sockets=shared' '--with-gmp=shared' '--with-curl=shared' '--with-openssl' '--with-zlib=/usr' ------------------------ Here's the backtrace. ------------------------ #0 0x4000af21 in _dl_debug_state () at dl-debug.c:56 #1 0x40182156 in _dl_close (map=0x80bfb50) at dl-close.c:195 #2 0x400a0430 in dlclose_doit (handle=0x80bfb50) at dlclose.c:26 #3 0x4000ac3b in _dl_catch_error (errstring=0x400a2080, operate=0x400a0418 <dlclose_doit>, args=0x80bfb50) at dl-error.c:141 #4 0x400a08b9 in _dlerror_run (operate=0x400a0418 <dlclose_doit>, args=0x80bfb50) at dlerror.c:125 #5 0x400a03fe in dlclose (handle=0x80bfb50) at dlclose.c:32 #6 0x4025b80e in module_destructor () at ltdl.c:1409 #7 0x4025e975 in zend_hash_destroy () at ltdl.c:1409 #8 0x4025a521 in zend_shutdown () at ltdl.c:1409 #9 0x4026c8a4 in php_module_shutdown () at ltdl.c:1409 #10 0x4026c868 in php_module_shutdown_wrapper () at ltdl.c:1409 #11 0x4026a715 in apache_php_module_shutdown_wrapper () at ltdl.c:1409 #12 0x80511d8 in ap_run_cleanup () at ltdl.c:1409 #13 0x804ffc9 in ap_clear_pool () at ltdl.c:1409 #14 0x805c326 in ap_child_terminate () at ltdl.c:1409 #15 0x805ca0f in main () at ltdl.c:1409 #16 0x400bb9cb in __libc_start_main (main=0x805c790 <main>, argc=2, argv=0xbffffb84, init=0x804f160 <_init>, fini=0x807bfbc <_fini>, rtld_fini=0x4000ae60 <_dl_fini>, stack_end=0xbffffb7c) at ../sysdeps/generic/libc-start.c:92 --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8920&edit=2 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]