FreeTDS Development Group

[John Kendall <john AT capps.com>]

> On Jun 5, 2016, at 5:12 AM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> 
> 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?

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 AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds