freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: John Kendall <john AT capps.com>
- To: FreeTDS Group <freetds AT lists.ibiblio.org>
- Subject: [freetds] bcp -n -E fails on identity column
- Date: Sun, 5 Jun 2016 08:56:43 +0000
Using the bcp -n (native file format) and -E (retain identity values) options
together produces:
Msg 20053, Level 4
Requested data conversion does not exist
I see this happening on Sybase (11 & 16) and MS SQL 2008.
Test to reproduce:
select id_col=identity(5) into tempdb..tbl -- Sybase
select id_col=identity(int) into tempdb..tbl -- MS SQL
$ freebcp tempdb..tbl out tbl.bcp -S $DSQUERY -U usr -P pw -n -E
Starting copy...
Msg 20053, Level 4
Requested data conversion does not exist
bcp copy out failed
datacopy also has a problem with the -E option, I assume the problems are
related.
John
-
[freetds] bcp -n -E fails on identity column,
John Kendall, 06/05/2016
-
Re: [freetds] bcp -n -E fails on identity column,
Frediano Ziglio, 06/05/2016
- Re: [freetds] [GRAYMAIL] bcp -n -E fails on identity column, John Kendall, 06/05/2016
- <Possible follow-up(s)>
-
Re: [freetds] bcp -n -E fails on identity column,
John Kendall, 06/22/2016
-
Re: [freetds] bcp -n -E fails on identity column,
Frediano Ziglio, 06/26/2016
-
Re: [freetds] bcp -n -E fails on identity column,
John Kendall, 06/26/2016
- Re: [freetds] bcp -n -E fails on identity column, Frediano Ziglio, 06/27/2016
- Re: [freetds] bcp -n -E fails on identity column, Frediano Ziglio, 06/27/2016
-
Re: [freetds] bcp -n -E fails on identity column,
John Kendall, 06/26/2016
-
Re: [freetds] bcp -n -E fails on identity column,
Frediano Ziglio, 06/26/2016
-
Re: [freetds] bcp -n -E fails on identity column,
Frediano Ziglio, 06/05/2016
Archive powered by MHonArc 2.6.24.