Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: BCP PROBLEM URGENT (using 11.1 Server from 12.5 )

    I am trying to execute a bcp from 12.5 version .The server I am bcp is 11.1 version Sybase
    When I execute the following command

    bcp fox.fox_USER.INSTRUMENT out test -Usa -P**** -STK_FOX1_UAT -c -t'\t' -r'\n' -eErrBcp.out

    It gives following erroe
    Server Message: TK_FOX1_UAT - Msg 4002, Level 14, State 1:
    Login failed.

    CTLIB Message: - L4/O1/S4/N44/4/0:
    ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
    Establishing connection failed.

  2. #2
    Join Date
    Nov 2003
    Posts
    3
    The above bcp command runs from other server that is 12.0 version server but not from 12.5

  3. #3
    Join Date
    Oct 2003
    Location
    Abu Dhabi
    Posts
    14
    Try the below bcp command

    bcp db_name..table_name out c:\xyz.txt -c -t\, -Uuser_name -Ppassword -Sserver_name

Posting Permissions

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