FreeTDS Development Group

[John Kendall <john AT capps.com>]

My last attempt to report this was a bit muddled.  Here's another try.  
Using version 1.00.6.

Using the bcp -n (native file format) and -E (retain identity values) options 
together produces:

   Msg 20060, Level 11
   Unknown datatype encountered

   Error in bcp_colfmt col 1


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
   Msg 20060, Level 11
   Unknown datatype encountered

   Error in bcp_colfmt col 1

datacopy also has a problem with the -E option, I assume the problems are 
related.

John