Results 1 to 2 of 2

Thread: BCP error

  1. #1
    Join Date
    Jan 2004
    Location
    USA
    Posts
    1

    Unanswered: BCP error

    Message 4845 bulk copy failed. Client doesn't have the capibility to bulk copy into the data-only locked table 'AxysEvent..AccountStatusChangeEvent'.


    I am getting the above error when I generate the BCP in a unix box and load them into another unix box. The bcp is generated using a c++ program.

    There is a difference in bcp versions. It is 10.0.3 at the source and 10.0.4 at target.

    SYbase document susggests dblib bulk copy application using dblib will not work with DOL pages you must either convert application to use ctlib or modify table lock scheme.

    We altered the lock scheme and it works fine. But is there a way to fix the issue permanently. Where could I get the ctlib?? How I can solve the issue.

    Please help us out.

    Thanks and Regards
    Gnana

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    ctlib is bundled with any newer ASE's. 12, 12.5, 12.5.1 and so forth. It also comes with the SDK and the Developers edition.

    dblib will not work on any of the later features intoruced since SQL Server 10.x It has been end of life since.

Posting Permissions

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