freebcp in -n native switch not working with Sybase

John Kendall <[email protected]> Wed, 4 May 2016 17:46:54 +0000

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

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?


John