Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

bcp pubs2 out establishing connection failed

2 posts in Windows NT Last posting was on 1999-12-17 18:54:33.0Z
Laura Yen Posted on 1999-12-17 15:13:56.0Z
Message-ID: <385A5334.F00588A7@us.ibm.com>
Date: Fri, 17 Dec 1999 10:13:56 -0500
From: Laura Yen <lyen@us.ibm.com>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: bcp pubs2 out establishing connection failed
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 15
NNTP-Posting-Host: ss06.nc.us.ibm.com 32.97.136.236
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2809
Article PK: 1090247

I am running ASE11.5.1 on NT 4.0 SP4.
When execute the following command,
bcp pubs2..publishers out pub_out -c -t , -r \n -Pxxxxxx
I got error:
Server Mesage: - Msg 4002, Level 14, State 1:
Login failed.
CTLIB MessageL - L4/01/S4/N44/4/0:
ct_connect(): protocol specific layer: external error: The attempt
to connect to the server failed.
Establishing connection failed.

Although I am able to use isql to select the data from publishers table.

Why do I have connection problem when use bcp ?

Thanks for your help.

Laura Yen


AnaMaria Stirbet Posted on 1999-12-17 18:54:33.0Z
Message-ID: <385A86E9.BCDFC8FD@sybase.com.no.spam>
Date: Fri, 17 Dec 1999 13:54:33 -0500
From: AnaMaria Stirbet <astirbet@sybase.com.no.spam>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: bcp pubs2 out establishing connection failed
References: <385A5334.F00588A7@us.ibm.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 18
NNTP-Posting-Host: 172.31.140.205
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2805
Article PK: 1090241

You're missing -U<login> switch.

AnaMaria Stirbet
Sybase TS

Laura Yen wrote:

> I am running ASE11.5.1 on NT 4.0 SP4.
> When execute the following command,
> bcp pubs2..publishers out pub_out -c -t , -r \n -Pxxxxxx
> I got error:
> Server Mesage: - Msg 4002, Level 14, State 1:
> Login failed.
> CTLIB MessageL - L4/01/S4/N44/4/0:
> ct_connect(): protocol specific layer: external error: The attempt
> to connect to the server failed.
> Establishing connection failed.
>
> Although I am able to use isql to select the data from publishers table.
>
> Why do I have connection problem when use bcp ?
>
> Thanks for your help.
>
> Laura Yen