Results 1 to 6 of 6

Thread: BCP Error

  1. #1
    Join Date
    Sep 2004
    Posts
    30

    Question Unanswered: 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

    Helena

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Interesting...you mean different servers, right...

    Collation not supported? Hmmmm...

    Is this SQL Server or sybase?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2002
    Location
    Prague
    Posts
    77
    Is there a difference between the computer with the problem and other machines where it's working fine in Windows Regional Settings? mojza

  4. #4
    Join Date
    Sep 2004
    Posts
    30
    Hi, Its runs ok on other PCs & for other users. The connection to MSSql 200 it with windows id.
    Thanks
    H

  5. #5
    Join Date
    Sep 2004
    Posts
    30
    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

  6. #6
    Join Date
    Sep 2004
    Posts
    30
    Hi,
    Thanks for the hint.
    I changed the Windows Regional Settings on the problemathic PC and now BCP works ok.

    Thanks again
    Helena

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •