freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

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

[freetds] freebcp in -n native switch not working with Sybase, John Kendall, 05/04/2016
- Re: [freetds] freebcp in -n native switch not working with Sybase, Igor Korot, 05/04/2016
- Re: [freetds] freebcp in -n native switch not working with Sybase, Frediano Ziglio, 05/10/2016
- Re: [freetds] freebcp in -n native switch not working with Sybase, Frediano Ziglio, 05/10/2016
  - Re: [freetds] freebcp in -n native switch not working with Sybase, John Kendall, 05/10/2016
- <Possible follow-up(s)>
- Re: [freetds] freebcp in -n native switch not working with Sybase, John Kendall, 05/04/2016