RE: ct_connect errors in xp_cmdshell
From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 12/17/04
- Next message: Grant Merwitz: "Re: JOB EXECUTING DTS PACKAGE FAILS"
- Previous message: Bryn: "SQL Server 2000: Cant Install on Win 2003 Server Web Edition"
- In reply to: Yog: "ct_connect errors in xp_cmdshell"
- Next in thread: Yog: "RE: ct_connect errors in xp_cmdshell"
- Reply: Yog: "RE: ct_connect errors in xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 17 Dec 2004 07:03:08 -0800
Hi
The Sybase BCP.exe is now being used by your call due to the environment
path settings written by the Sybase setup.
Fully qualify the BCP.exe path in the call and it will work. osql.exe is
also affected in the same way.
Regards
Mike
"Yog" wrote:
> 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.
>
>
>
- Next message: Grant Merwitz: "Re: JOB EXECUTING DTS PACKAGE FAILS"
- Previous message: Bryn: "SQL Server 2000: Cant Install on Win 2003 Server Web Edition"
- In reply to: Yog: "ct_connect errors in xp_cmdshell"
- Next in thread: Yog: "RE: ct_connect errors in xp_cmdshell"
- Reply: Yog: "RE: ct_connect errors in xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
