Post reply

BCP Error: CTLIB Message: - L6/O8/S5/N3/5/0: ct_connect():

  • April 26, 2005 at 3:20 am

    #92944

    When iam executing the bcp command from command prompt it is working fine but when i execute it using the T-Sql script it is giving the error

    CTLIB Message:  - L6/O8/S5/N3/5/0:

    ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

    Establishing connection failed.

    BCP Command which i used is

    exec master..xp_cmdshell 'BCP CCSProd.dbo.BcpTestTable out D:\DataDumps\BcpDumpTest.txt -c -t ## -r \n  -SMyServer -UUser -PPwd'

     

    Thanks in advance for your suggestions.

  • April 29, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • January 15, 2008 at 1:49 pm

    #768319

    I am facing this same issue and I guess this is related to the fact that the sql server is not being recognized within the network . still looking at options

  • December 14, 2008 at 12:27 am

    #912165

    As what I've read from other forums, one of the reasons for this error message is a conflict with Sybase Server. If you also have Sybase Server (ASE,SQL Anywhere) installed on your computer this may be the cause. If no, try to indicate the ip address on the server parameter with the port number. and instance name(e.g ) -Stcp:192.168.0.10,1433\Instancename.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply