Re: freebcp in -n native switch not working with Sybase

On Wed, May 4 14:28:21 EDT 2016 Igor Korot <ikorot01 at gmail.com> wrote: 

> Hi, John,
> 
> On Wed, May 4, 2016 at 1:46 PM, John Kendall <john at capps.com> wrote:
> > On MS SQL Server this works:
> >
> >    select col1="one", col2="2" into tempdb..tbl
> >
> >    freebcp tempdb..tbl out tbl.bcp -n -Uusr -Ppw
> >    freebcp tempdb..tbl in  tbl.bcp -n -Uusr -Ppw
> >
> > On Sybase the bcp in fails like so:
> >
> >    Starting copy...
> >
> >    Msg 20104, Level 3
> >    Unexpected EOF encountered in bcp datafile
> >
> >    bcp copy in failed
> >
> >
> > Notes:
> > The bcp file created is identical for on both server flavors.
> > Using the character -c option works.
> >
> > Anyone else able to reproduce this problem?
> 
> Which version of the servers you use?

11.02 and 16.0

> Thank you.
> 
> >
> >
> > John
>