[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] [GRAYMAIL]  bcp -n -E fails on identity column
From:       John Kendall <john () capps ! com>
Date:       2016-06-05 17:15:34
Message-ID: 466F87BD-615A-452E-877D-7D774D1D49BD () capps ! com
[Download RAW message or body]


> On Jun 5, 2016, at 5:12 AM, Frediano Ziglio <freddy77@gmail.com> wrote:
> 
> On 5 Jun 2016 09:56, "John Kendall" <john@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?

Sorry, those error messages came from an old v0.95.19 install.

Using version 1.0, the bcp still fails, but with this message:


    Msg 20060, Level 11
    Unknown datatype encountered

    Error in bcp_colfmt col 1



> 
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]