DBD-Sybase: Re: number of rows affected with freetds

Edmund Mergl E.Mergl at bawue.de
Mon Jul 17 14:16:39 EDT 2000


Bob Kline wrote:
> 
> On Mon, 17 Jul 2000, Daniel Bruce Lynes wrote:
> 
> > On Sun, 16 Jul 2000, Edmund Mergl wrote:
> >
> > > it looks like freetds does not handle the number of rows affected
> > > by the SQL-statement, eg:
> > >
> > > DBD-Sybase + sybase-libs + sybase-11.9.2 on linux
> > >
> > >    successful insert              ret = 1
> > >    insert with error              ret = undef
> > >
> > >    successful update              ret = 1
> > >    update with record not found   ret = 0E0
> > >    update with error              ret = undef
> > >
> > > DBD-Sybase + freetds + sybase-11.9.2 on linux
> > >
> > >    successful insert              ret = -1
> > >    insert with error              ret = undef
> > >
> > >    successful update              ret = -1
> > >    update with record not found   ret = -1
> > >    update with error              ret = undef
> > >
> > >
> > > is this a general problem or can this be fixed ?
> >
> >  From the work I've done with the ODBC library using the same Sybase
> > database under Linux, it seems to work fine.  Perhaps it's a bug in
> > DBD?  The ODBC driver also uses the freetds libraries.
> 
> It would need to be a pretty subtle bug in DBD, I should think, given
> the fact that it works properly when linked with Sybase's libraries
> (assuming he's using the same version of DBD-Sybase in both cases).
> 
> --
> Bob Kline
> mailto:bkline at rksystems.com
> http://www.rksystems.com


well I thought when only changing the driver lib (freetds -> sybase)
and the problem disappears, the faulty part must be freetds, but I might
be wrong.

May be someone from the DBI list can comment on this ?


Edmund


-- 
Edmund Mergl
mailto:E.Mergl at bawue.de
http://www.edmund-mergl.de
fon: +49 700 EDEMERGL



More information about the FreeTDS mailing list