FreeTDS Development Group

[Matthew <matthew.green AT datamartcomputing.com>]

Thanks for the kind words. It seems I must have missed something as 
datacopy is working for me when copying DATE and TIME columns from ASE 
15.7 to ASE 15.7.

A lot of what I did was trial and error and I tried to remember to leave 
a comment so I could find what I'd changed in order to write it up at 
the end.

Any idea which file I would have changed to get it working with dblib? 
If not I'll untar the package somewhere else and run a find and diff to 
see if I can spot it.

Cheers,

Matthew.

On 13/09/15 11:55, Frediano Ziglio wrote:
> 2015-09-11 10:04 GMT+01:00  <matthew.green AT datamartcomputing.com>:
> > Dear All,
> >
> > I'm not really a C programmer (or C++ for that matter) but I wanted to be 
> > able to use datacopy to copy tables with DATE and TIME data types. So, I 
> > decided to have a crack at adding them to FreeTDS.
> >
> > My testing has been successful, although I'm not sure the way I've coded it 
> > is correct so any help/fixes would be appreciated.
> >
> > I've attached a rich text document with the details. The first part proposes a quick 
> > and dirty fix, while the second is my best guess at the "correct" way of 
> > doing things.
> >
> > Bare in mind that this is currently only for Sybase to Sybase. I'm going to 
> > look at doing this for SQL Server too but that's a bit more complicated!
> >
> > Cheers,
> >
> > Matthew.
>
> Patch and effort are really appreciated.
> So appreciated that I already pushed some changes and is actually
> testing deeply (but I don't think there will be any regression).
>
> datacopy still does not work as SYBDATE/SYBTIME are not supported by
> dblib (you added support for libTDS not upper libraries and datacopy
> is based on dblib).
>
> Currently converting from string will use datetime format in all
> cases. ODBC has its standard so format strings are well defined for
> it.
>
> I added some improvements too based on previously patches on some other types.
>
> Yes, adding a new type in FreeTDS is really a nightmare !!!
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds