I use the following
bcp bwsql..saleinfo in saleinfo.txt -f saleinfo.fmt -Usa -P
bcp works fine with Sql Server 7.0 on an XP pro box,
but the same statement doesn't work with SQL Server 7.0 on an NT based machine
I get an "attempt to read unknown version of bcp format file" error.
The Version number in the format file is 8.0, and it works fine on XP machine.
If I change version number in format file to 7.0, the error changes to "incorrect host-column number found in BCP format file"
same database copied to both servers, same format files, data files, everything is the same except the operating system.
Any Ideas??
bcp bwsql..saleinfo in saleinfo.txt -f saleinfo.fmt -Usa -P
bcp works fine with Sql Server 7.0 on an XP pro box,
but the same statement doesn't work with SQL Server 7.0 on an NT based machine
I get an "attempt to read unknown version of bcp format file" error.
The Version number in the format file is 8.0, and it works fine on XP machine.
If I change version number in format file to 7.0, the error changes to "incorrect host-column number found in BCP format file"
same database copied to both servers, same format files, data files, everything is the same except the operating system.
Any Ideas??