Prev: Compile php5-sybase_ct-5.2.9 with freetds-devel-0.82.1_1,1 in FreeBSD ports will Failed!
Next: mysqli_multi_query error tolerance
From: Steven Cruz on 26 Mar 2009 09:11 Hello; I had several problem installing Sybase 15 64 bit with php 5, I was using sybase open client libraries and with some twinking I got it to work, with compile warnings. Have you tried the native Sybase client libraries? steven. James Chang wrote: > Dear Sir, > > I'm running almost 300 boxes of FreeBSD with PHP 5.2.9 as my Web > Application front-end. > > Because my backend DB Server is Sybase ASE 15.0.2, I need to re-build my > php5-sybase_ct-5.2.9 with FreeTDS 0.82(or above). Or I will encounter truncated > problem when column type is Char(n), VarChar(n), Binary(n), and VarBinary(n) > datatypes where n is more than 255 bytes. > > Could you please do me a favor ? > > Best Regards! > > P.S. > 1.The following is compiling Error message :< > /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/php_sybase_ct.c:809: > warning: cast from pointer to integer of different size > /bin/sh /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/libtool > --mode=link cc -DPHP_ATOM_INC > -I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/include > -I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/main > -I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct > -I/usr/local/include/php -I/usr/local/include/php/main > -I/usr/local/include/php/TSRM -I/usr/local/include/php/Zend > -I/usr/local/include/php/ext -I/usr/local/include/php/ext/date/lib > -I/usr/local/include -I/usr/local/include/php -DHAVE_CONFIG_H -O3 > -fno-strict-aliasing -pipe -march=opteron -o ./sybase_ct.la > -export-dynamic -avoid-version -prefer-pic -module -rpath > /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/modules > php_sybase_ct.lo -lsybtcl -lintl -lcomn -lct -lcs -R/usr/local/lib > -L/usr/local/lib > cc -shared .libs/php_sybase_ct.o -Wl,--rpath -Wl,/usr/local/lib > -Wl,--rpath -Wl,/usr/local/lib -lsybtcl /usr/local/lib/libintl.so > -L/usr/local/lib -lcomn /usr/local/lib/libct.so -L/usr/lib -lcs > -march=opteron -Wl,-soname -Wl,sybase_ct.so -o ./.libs/sybase_ct.so > /usr/bin/ld: cannot find -lsybtcl > *** Error code 1 > > Stop in /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct. > > > 2.The following are the FreeTDS log: > ================================================================== > 15:51:06.317420 48508 (net.c:542):Received packet > 0000 25 00 00 01 0a 05 30 31-30 30 34 00 01 00 b7 00 |%.....01 004.....| > 0010 43 68 61 72 61 63 74 65-72 20 6f 72 20 62 69 6e |Characte r or bin| > 0020 61 72 79 20 64 61 74 61-20 72 65 74 75 72 6e 65 |ary data returne| > 0030 64 20 66 72 6f 6d 20 41-64 61 70 74 69 76 65 20 |d from A daptive | > 0040 53 65 72 76 65 72 20 68-61 73 20 62 65 65 6e 20 |Server h as been | > 0050 74 72 75 6e 63 61 74 65-64 2e 20 54 68 65 20 63 |truncate d. The c| > 0060 6c 69 65 6e 74 20 61 70-70 6c 69 63 61 74 69 6f |lient ap plicatio| > 0070 6e 20 64 6f 65 73 20 6e-6f 74 20 73 75 70 70 6f |n does n ot suppo| > 0080 72 74 20 6d 6f 72 65 20-74 68 61 6e 20 32 35 35 |rt more than 255| > 0090 20 62 79 74 65 73 20 6f-66 20 64 61 74 61 20 61 | bytes o f data a| > 00a0 73 20 61 20 72 65 73 75-6c 74 20 63 6f 6c 75 6d |s a resu lt colum| > 00b0 6e 20 6f 72 20 6f 75 74-70 75 74 20 70 61 72 61 |n or out put para| > 00c0 6d 65 74 65 72 2e 0a 06-64 6f 72 6f 72 6f 00 01 |meter... dororo..| > 00d0 00 fd 10 00 02 00 01 00-00 00 |........ ..| > ================================================================== > i.e. Sybase ASE 15.0.2 response:"Character or binary data returned > from Adaptive Server has been truncated. The client application does > not support more than 255 bytes of data as a result column or output > parameter." > > |