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.

Can NT bcp write to a named pipe?

2 posts in Windows NT Last posting was on 2000-03-03 00:21:07.0Z
Mary-Rose McBrien Posted on 2000-03-01 15:46:02.0Z
Message-ID: <38BD3B3A.5B16B409@harco.co.uk>
Date: Wed, 01 Mar 2000 15:46:02 +0000
From: Mary-Rose McBrien <mary-rose.mcbrien@harco.co.uk>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Can NT bcp write to a named pipe?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 13
NNTP-Posting-Host: modem-16.zinc.dialup.pol.co.uk 62.136.29.16
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2471
Article PK: 1089926

I have created a NT using the Windows NT API CreateNamedPipe.
In the same C code, I then do a system call to perform a Sybase bcp out
specifying the named pipe as the output file. I get the error:
Invalid argument.
Bcp: Unable to open host file.

If the pipe did not exist, I get:
No such file or directory
instead of
Invalid argument.

Can Sybase bcp write to a named pipe? Perhaps the arguments
I give to CreateNamedPipe are incorrect? Please help - I'm really stuck!


Mohammed Posted on 2000-03-03 00:21:07.0Z
Message-ID: <38BF0573.4D294728@yahoo.com>
Date: Thu, 02 Mar 2000 16:21:07 -0800
From: Mohammed <shariquem@yahoo.com>
Reply-To: shariquem@yahoo.com
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Can NT bcp write to a named pipe?
References: <38BD3B3A.5B16B409@harco.co.uk>
Content-Type: multipart/mixed; boundary="------------707B63D330F68DDE560DFA01"
Newsgroups: sybase.public.sqlserver.nt
Lines: 34
NNTP-Posting-Host: dns-sf-01.barclaysglobal.com 208.32.26.78
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2462
Article PK: 1089915

i've bcp'ed using named pipes to a tape on sco and solaris. so, it is
doable. i can email the code if u want it.

Mary-Rose McBrien wrote:

> I have created a NT using the Windows NT API CreateNamedPipe.
> In the same C code, I then do a system call to perform a Sybase bcp out
> specifying the named pipe as the output file. I get the error:
> Invalid argument.
> Bcp: Unable to open host file.
>
> If the pipe did not exist, I get:
> No such file or directory
> instead of
> Invalid argument.
>
> Can Sybase bcp write to a named pipe? Perhaps the arguments
> I give to CreateNamedPipe are incorrect? Please help - I'm really stuck!


Download VCard shariquem.vcf