1000 Attempt to read unknown version of BCP format file

27 Nov 2007 2:54 PM

PhilHibbs

On our machine, running SQL Server 7, we don't get any problems.
However, on a client's SQL Server 7 machine, we get the error message:

SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQLServer Driver]Attempt to read unknown
version of BCP format file

Any ideas? I can't remember how I created the BCP format file, but it
begines with the line "8.0", and we tried changing this to "7.0" and
then we get this:

SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column
number found in BCP format-file

Any ideas why one machine might be fine but the other complain about
the version? Both machines say "7.00.494" from bcp -v.

Phil Hibbs.

27 Nov 2007 4:21 PM

Russell Fields

Phil,

You should check the version of bcp being used at both locations. It is
very possible that one bcp.exe is actually an older version that is hanging
around in the command path. (It might still be a 6.5 copy of bcp.)

RLF

Show quote

"PhilHibbs" <sna***@gmail.com> wrote in message
news:4ecdcb9a-eafd-4852-aa74-5a54ba91337c@l1g2000hsa.googlegroups.com...
> On our machine, running SQL Server 7, we don't get any problems.
> However, on a client's SQL Server 7 machine, we get the error message:
>
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQLServer Driver]Attempt to read unknown
> version of BCP format file
>
> Any ideas? I can't remember how I created the BCP format file, but it
> begines with the line "8.0", and we tried changing this to "7.0" and
> then we get this:
>
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column
> number found in BCP format-file
>
> Any ideas why one machine might be fine but the other complain about
> the version? Both machines say "7.00.494" from bcp -v.
>
> Phil Hibbs.

27 Nov 2007 11:05 PM

Erland Sommarskog

PhilHibbs (sna***@gmail.com) writes:
Show quote

> On our machine, running SQL Server 7, we don't get any problems.
> However, on a client's SQL Server 7 machine, we get the error message:
>
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQLServer Driver]Attempt to read unknown
> version of BCP format file
>
> Any ideas? I can't remember how I created the BCP format file, but it
> begines with the line "8.0", and we tried changing this to "7.0" and
> then we get this:
>
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column
> number found in BCP format-file

I'm might be asking for cheating, but it would help to see that format
file. A tip, though, is that if there is a column after the column
name for the collation, you should remove it, as it is not present in
the 7.0 format.

> Any ideas why one machine might be fine but the other complain about
> the version? Both machines say "7.00.494" from bcp -v.

Something is not right here. bcp7 would never accept 8.0 as the
format-file version, so the machine you ran that on must have had BCP8
or later.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx