FreeTDS Development Group

["Paul Schaap" <Paul.Schaap AT dingoblue.com.au>]

Brian,

On 09/11/99, "Brian Bruns <camber AT umcc.ais.org>" wrote:
> sqsh links dynamically for me, I guess I'd have to look to see if maybe
> PHP links statically.  I don't think so, but I have no other explaination
> at the moment. 
>

I was fairly certain php is linked dynamically with freetds as with 
previous changes to freetds all I have had to do is restart apache for the 
change to take effect. This is what prompted me to ask the question in the 
first place, I can only assume I've missed something though I'm yet to 
figure out what ...
 
> I've put together a test program for try out STRINGBIND and NTBSTRINGBIND
> behaviour. It tests all combinations of char/nullable char/varchar for
> both bind types. So, when all this is done we should at least be able to
> verify we have the correct behaviour in all cases.
> 

great

> Cheers,
> 
> Brian
> 
> On Sat, 11 Sep 1999, Paul Schaap wrote:
> 
> > Brian,
> > 
> > On 09/11/99, "Brian Bruns <camber AT umcc.ais.org>" wrote:
> > > Ok, changes are in CVS, also I was off by one in the detecting of SQL7.0
> > > so that didn't work either.  I tested it on Solaris and everything looks
> > > good. (If I remember to check in the right version this time :)
> > > 
> > 
> > I got down a new copy of the CVS and tested and and it works perfectly,
> > under
> > sqsh that is. Under PHP (3.0.12) it doesnt seem to be working even though 
> > I
> > have
> > stop and started apache ??? Could the old library still be in memory or is
> > the link with php different to the link with sqsh ?
> > 
> > > Brian
> > > 
> > > On Sat, 11 Sep 1999, Paul Schaap wrote:
> > > 
> > > > Martin,
> > > > 
> > > > On 09/11/99, "Martin Spott <martin AT quickstep.oche.de>" wrote:
> > > > > When I watched the log of my cron job doing the daily compile I, 
> > > > > recognized
> > > > > that it failed today:
> > > > > 
> > > > > [...]
> > > > > make[2]: Entering directory `/usr/local/src/freetds/src/tds'
> > > > > /bin/sh ../../libtool --mode=compile gcc -DPACKAGE=\"freetds\" 
> > > > > -DVERSION=\"0.46\" -DSTDC_HEADERS=1 -DHAVE_SYS_WAIT_H=1 
> > > > > -DHAVE_UNISTD_H=1 -DWORDS_BIGENDIAN=1 -DHAVE_STRFTIME=1  -I. -I.  
> > > > > -I../../include    -g -O2 -DHW_BIG_ENDIAN -DTDS50 -c mem.c
> > > > > gcc -DPACKAGE=\"freetds\" -DVERSION=\"0.46\" -DSTDC_HEADERS=1 
> > > > > -DHAVE_SYS_WAIT_H=1 -DHAVE_UNISTD_H=1 -DWORDS_BIGENDIAN=1 
> > > > > -DHAVE_STRFTIME=1 -I. -I. -I../../include -g -O2 -DHW_BIG_ENDIAN 
> > > > > -DTDS50 -Wp,-MD,.deps/mem.pp -c  -fPIC -DPIC mem.c -o mem.lo
> > > > > /bin/sh ../../libtool --mode=compile gcc -DPACKAGE=\"freetds\" 
> > > > > -DVERSION=\"0.46\" -DSTDC_HEADERS=1 -DHAVE_SYS_WAIT_H=1 
> > > > > -DHAVE_UNISTD_H=1 -DWORDS_BIGENDIAN=1 -DHAVE_STRFTIME=1  -I. -I.  
> > > > > -I../../include    -g -O2 -DHW_BIG_ENDIAN -DTDS50 -c token.c
> > > > > gcc -DPACKAGE=\"freetds\" -DVERSION=\"0.46\" -DSTDC_HEADERS=1 
> > > > > -DHAVE_SYS_WAIT_H=1 -DHAVE_UNISTD_H=1 -DWORDS_BIGENDIAN=1 
> > > > > -DHAVE_STRFTIME=1 -I. -I. -I../../include -g -O2 -DHW_BIG_ENDIAN 
> > > > > -DTDS50 -Wp,-MD,.deps/token.pp -c  -fPIC -DPIC token.c -o token.lo
> > > > > token.c: In function `tds_process_row':
> > > > > token.c:582: `SYBDATETIMEN' undeclared (first use in this function)
> > > > > token.c:582: (Each undeclared identifier is reported only once
> > > > > token.c:582: for each function it appears in.)
> > > > > token.c:585: parse error before `{'
> > > > > token.c:603: `more_results' undeclared (first use in this function)
> > > > > token.c:603: `tmp' undeclared (first use in this function)
> > > > > token.c:604: `was_cancelled' undeclared (first use in this function)
> > > > > token.c:613: parse error before `int'
> > > > > token.c:617: `level' undeclared (first use in this function)
> > > > > token.c:618: `state' undeclared (first use in this function)
> > > > > token.c:620: `line' undeclared (first use in this function)
> > > > > token.c:621: `message' undeclared (first use in this function)
> > > > > token.c: At top level:
> > > > > token.c:624: parse error before `}'
> > > > > make[2]: *** [token.lo] Error 1
> > > > > make[2]: Leaving directory `/usr/local/src/freetds/src/tds'
> > > > > make[1]: *** [all-recursive] Error 1
> > > > > make[1]: Leaving directory `/usr/local/src/freetds/src'
> > > > > make: *** [all-recursive] Error 1
> > > > > 
> > > > > 
> > > > > When I look at the source it seems for me _not_ to be a typo !?
> > > > > 
> > > > 
> > > > Brians trying to fix the MS SQL 7 bit for me (and others?) and I 
> > > > believe it
> > > > is a typo ! I 'think' the following patch is what he meant and allows 
> > > > a
> > > > compile, but I tried it for the date fix and it didnt work :-(
> > > > 
> > > > diff -urN freetds/src/tds/token.c freetds_11091999/src/tds/token.c
> > > > --- freetds/src/tds/token.c     Sat Sep 11 23:35:22 1999
> > > > +++ freetds_11091999/src/tds/token.c    Sun Sep 12 00:10:07 1999
> > > > @@ -578,11 +578,11 @@
> > > >                 */
> > > >                 if (tds->broken_dates &&
> > > >                    (curcol->column_type == SYBDATETIME ||
> > > > -                  (curcol->column_type == SYBDATETIME4 ||
> > > > -                  (curcol->column_type == SYBDATETIMEN ||
> > > > -                  (curcol->column_type == SYBMONEY ||
> > > > -                  (curcol->column_type == SYBMONEY4 ||
> > > > -                  (curcol->column_type == SYBMONEYN)) {
> > > > +                   curcol->column_type == SYBDATETIME4 ||
> > > > +                   curcol->column_type == SYBDATETIMN ||
> > > > +                   curcol->column_type == SYBMONEY ||
> > > > +                   curcol->column_type == SYBMONEY4 ||
> > > > +                   curcol->column_type == SYBMONEYN)) {
> > > >                         memcpy(temp_buf,dest,colsize/2);
> > > >                         memcpy(dest,&dest[colsize/2],colsize/2);
> > > >                         memcpy(&dest[colsize/2],temp_buf,colsize/2);
> > > > 
> > > > 
> > > > 
> > > > > Martin.
> > > > > -- 
> > > > >  Unix _IS_ user friendly - it's just selective about who its 
> > > > > friends are !
> > > > > --------------------------------------------------------------------------
> > > > 
> > > > REGARDS
> > > > Paul
> > > > 
> > > > ---
> > > > You are currently subscribed to freetds as: camber AT ais.org
> > > > To unsubscribe, forward this message to $subst('Email.Unsub')
> > > > 
> > > >
> > 
> > REGARDS
> > Paul
> > 
> > ---
> > You are currently subscribed to freetds as: camber AT ais.org
> > To unsubscribe, forward this message to $subst('Email.Unsub')
> > 
> >
REGARDS
Paul