freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Frediano Ziglio <freddy77 AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] bcp -n -E fails on identity column
- Date: Sun, 5 Jun 2016 13:12:48 +0100
On 5 Jun 2016 09:56, "John Kendall" <john AT capps.com> wrote:
>
> 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
>
>
Which FreeTDS version are you using?
Frediano
-
[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.