Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

bcp problem - OS related?

Status
Not open for further replies.

biggoober

Programmer
Oct 3, 2001
22
US
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??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top