Re: Incorrect host-column number found in BCP format-file

Michelle Hillard ([EMAIL PROTECTED]) writes:
> bcp.fmt
> 
> 8.00.194
> 6
> 1  SQLCHAR  0  20   ", "   0  filler_1          ""
> 2  SQLCHAR  0  8   "\r\n"  1  computer_name     ""
> 3  SQLCHAR  0  20  ", "    0  filler_2          ""
> 4  SQLCHAR  0  16  "\r\n"  2  ip_address        ""
> 5  SQLCHAR  0  20  ", "    0  filler_3          ""
> 6  SQLCHAR  0  60  "\r\n"  3  operating_system  ""
>... 
> C:\bcp>for /F %i in ('dir /b /on c:\bcp\pc*.txt') do bcp Inventory..pc in
> %i -fc:\bcp\bcp.fmt -T -S CHICKYy
> 
> C:\bcp>bcp Inventory..pc in pc1.txt -fc:\bcp\bcp.fmt -T -S CHICKYy
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column number
> found in BCP format-file

BCP's is not famous for its self-explanatory messages.

My guess goes to the version number. It should say 8.0, not 8.00.194.

(And if you are running 8.00.194 somewhere, you should download and
install SP3 for SQL Server to get a couple of important bug and
security fixes.)

-- 
Erland Sommarskog, SQL Server MVP, [EMAIL PROTECTED]

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp