bcp command execution incoherence

bcp sqlbulkcopy sql-server

Question

I execute a bcp command in 2 computer. The first computer has windows xp and second one has windows server 2003. when I execute command in first, the bcp run successfully but when I run this on second one, occur this error:

Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 720 is not supp
orted by SQL Server
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collat
ions

BCP copy out failed

what is the problem?

1
1
2/21/2010 6:22:44 AM

Popular Answer

You might take a look at the following article and play with the switches in you BCP statement.

Copying Data Between Different Collations

0
2/3/2011 4:13:28 AM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow