bcp command execution incoherence

bcp sqlbulkcopy sql-server

Question

I run a bcp command across two computers. Windows XP is installed on the first machine, while Windows Server 2003 is on the second. The bcp runs correctly when I run the command in the first case, but this problem occurs when I run it on the second case:

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's the issue?

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

Popular Answer

You might read the article below and experiment with the switches in your BCP declaration.

Transforming Data Between 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