ct_connect errors in xp_cmdshell

From: Yog (Yog_at_discussions.microsoft.com)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 06:49:08 -0800

I am running a bcp from xp_cmdshell, it was working good

EXEC master.dbo.xp_cmdshell 'bcp DATABASE1..V_TMP_KEYWORDSMMS2 out
c:\Keywords\KEYWORD_00000115_16_12_2004_17_47_27.txt -c -t~ -SSYN0001
-UUserName -Ppassword '

The server is Microsoft SQL Server 2000 - 8.00.760

Then I installed sybase client in the PC inorder to get replication from
sybase to sql server.

It is giving the following error message.

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.
NULL

Any help why is this happenning?

The server, username, password are all correct and I am able to work through
the enterprise manager and query analyser, its gving error only in the
xp_cmdshell and bcp.

After the install, the xp_cmdshell and bcp is not working anymore.

Relevant Pages

  • RE: ct_connect errors in xp_cmdshell
    ... The Sybase BCP.exe is now being used by your call due to the environment ... > Then I installed sybase client in the PC inorder to get replication from ... Requested server name not found. ... the xp_cmdshell and bcp is not working anymore. ...
    (microsoft.public.sqlserver.server)
  • Re: Whats the bcp (SQL Server) substitute in Oracle??
    ... secured UNIX server using the bcp utility of SQL Server. ... But now this database will be migrated to Oracle 10g. ... Flat File and Out File. ...
    (comp.databases.oracle.misc)
  • Whats the bcp (SQL Server) substitute in Oracle??
    ... secured UNIX server using the bcp utility of SQL Server. ... Flat File and Out File. ...
    (comp.databases.oracle.misc)
  • Re: BCP error 22001 - String data, right truncation
    ... application developers strip those types of garbage characters out before ... > Once I switched to native mode the problem went away. ... >> First be sure the table schema on the target server matches the one on ... >>>I am using bcp to copy a table from one sql server to another. ...
    (microsoft.public.sqlserver.tools)
  • Re: Whats the bcp (SQL Server) substitute in Oracle??
    ... secured UNIX server using the bcp utility of SQL Server. ... But now this database will be migrated to Oracle 10g. ... Flat File and Out File. ...
    (comp.databases.oracle.misc)