Skip to Content.
Sympa Menu

freetds - [freetds] freebcp in -n native switch not working with Sybase

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: John Kendall <john AT capps.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] freebcp in -n native switch not working with Sybase
  • Date: Wed, 4 May 2016 17:46:54 +0000

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






Archive powered by MHonArc 2.6.24.

Top of Page