Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    104

    Unanswered: sybase 12.5 bcp failed for a table

    Hello all,

    Can anybody please tell me is there any particular setting in sybase 12.5 which disables BCP into a particular table

    My problem is i am trying to bcp in data in 6 tables out of which in 5 tables data goes in and in 1 table it says

    --------------------------------------------------------------------
    Server Message: CDPPUDW - Msg 4806, Level 16, State 1:
    You cannot run the non-logged version of bulk copy in this database. Please chec
    k with the DBO.

    CTLIB Message: - L0/O0/S0/N0/0/0:
    blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results()
    called.
    blk_init failed.
    -----------------------------------------------------------------------

    Please help,urgent
    thanx for ur help
    ---Pooja

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Looks like "SELECT INTO" option is not set for this database. Use sp_dboption and check what is set

  3. #3
    Join Date
    Dec 2002
    Posts
    104
    Originally posted by willy_and_the_ci
    Looks like "SELECT INTO" option is not set for this database. Use sp_dboption and check what is set
    thanx .....yeah this option is not set in db.

Posting Permissions

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