2012年3月6日星期二

BCP Error

CP Activation Error
-------

The following command runs on several PCs without any problems,
but on one of the computers + user the bcp resulting with error

Env:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
SQL Server: win 2000 server
PCs: win 2000 professional

Command:
"bcp" "select a, b from db_name.dbo.tbl_name WHERE (c = 0) ORDER BY a" "queryout" "\\pc-name\dir1\dir2\file-name.p" "-Ssrv" "-T" "-c"

Result:
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 862 is not supported by SQL Server
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collations

BCP copy out failed

Please, help me to solve this problem

HelenaInteresting...you mean different servers, right...

Collation not supported? Hmmmm...

Is this SQL Server or sybase?|||Is there a difference between the computer with the problem and other machines where it's working fine in Windows Regional Settings? mojza|||Hi, Its runs ok on other PCs & for other users. The connection to MSSql 200 it with windows id.
Thanks
H|||Hi,
There is only MsSql server 2000, no Sybase involved.
I Don't know the setting of the computers - whot chell i check ?
Thanks
Helena|||Hi,
Thanks for the hint.
I changed the Windows Regional Settings on the problemathic PC and now BCP works ok.

Thanks again
Helena

没有评论:

发表评论