RE: ct_connect errors in xp_cmdshell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Fri, 17 Dec 2004 10:49:11 -0800

Thank you Mike, that worked.

"Mike Epprecht (SQL MVP)" wrote:

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

Relevant Pages

  • Return a single value from a Sybase stored procedure using ADO
    ... I need to return a number from a Sybase SQLAnywherestored procedure ... The error message appears at the "While Not" line ... Dim objConn As Object ... Dim objRs As Object ...
    (microsoft.public.vb.database.ado)
  • Re: Return a single value from a Sybase stored procedure using ADO
    ... I need to return a number from a Sybase SQLAnywherestored procedure ... proper value but I get error on the ADO call. ... The error message appears at the "While Not" line ... Dim objRs As Object ...
    (microsoft.public.vb.database.ado)
  • Re: No line number with RaiseError in DBD::Sybase
    ... error message does not indicate what line number of the program that the ... is a lot of conditional concatenating in that function, ... retcode = CS_SUCCEED; ... Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com ...
    (perl.dbi.users)
  • Re: Specify owner.objectname or use sp_helpdb
    ... I am sorry but there is no other error message. ... have tested several applications with the ODBC Driver(Original Sybase) on ... different Computers, the error is always the same, somtimes the ODBC driver ... Specify owner.objectname or use sp_help to check whether the object exists ...
    (comp.databases.sybase)