Microsoft Visual studio 2005 - bcp path error

[dashary via WinServerKB.com]

I am running the bcp utility under Microsoft Visual studio 2005 and receive

the following in the progress log:



[Execute Process Task] Warning: File/Process "bcp" is not in path.



a few lines later the process fails





:[Execute Process Task] Error: In Executing "bcp" " "FDMS.[DBO].[EXPORT_TUFTS]



" out "E:\DBProg\FDMS\TUFTS\Output\TuftsExport_0.txt" -c -S azshDSD16v -C ACP

-t "|" -T" at "", The process exit code was "1" while the expected was "0".



It looks like the "bcp" utility cannot be found. When I do a "PATH" in the

windows command window the path for the utility is present ("C:\Program Files\



Microsoft SQL Server\90\Tools\binn\" see below). Is there somewhere else I

need to look for the path?



Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.



H:\>path

PATH=C:\WINDOWS\system32C:\WINDOWSC:\WINDOWS\System32\WbemC:\Program Files\



Ex

ecutive Software\Diskeeper\C:\Program Files\Microsoft SQL Server\80\Tools\

Binn\

C:\Program Files\Microsoft SQL Server\90\Tools\binn\C:\Program Files\

Microsoft

SQL Server\90\DTS\Binn\C:\Program Files\Microsoft SQL Server\90\Tools\Binn\

VSS

hell\Common7\IDE\C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\

Private

Assemblies\



H:\>



--

Message posted via WinServerKB.com

http://www.winserverkb.com/Uwe/Forums.aspx/windows-2000-general/201003/1

 

[Dave Patrick]

What happens if you do a



bcp /?



from a cmd.exe session?







--



Regards,



Dave Patrick ....Please no email replies - reply in newsgroup.

Microsoft Certified Professional

Microsoft MVP [Windows]

http://www.microsoft.com/protect



"dashary via WinServerKB.com" wrote:

>I am running the bcp utility under Microsoft Visual studio 2005 and receive

> the following in the progress log:

>

> [Execute Process Task] Warning: File/Process "bcp" is not in path.

>

> a few lines later the process fails

>

>

> :[Execute Process Task] Error: In Executing "bcp" "

> "FDMS.[DBO].[EXPORT_TUFTS]

>

> " out "E:\DBProg\FDMS\TUFTS\Output\TuftsExport_0.txt" -c -S azshDSD16v -C

> ACP

> -t "|" -T" at "", The process exit code was "1" while the expected was

> "0".

>

> It looks like the "bcp" utility cannot be found. When I do a "PATH" in the

> windows command window the path for the utility is present ("C:\Program

> Files\

>

> Microsoft SQL Server\90\Tools\binn\" see below). Is there somewhere else I

> need to look for the path?

>

> Microsoft Windows XP [Version 5.1.2600]

> (C) Copyright 1985-2001 Microsoft Corp.

>

> H:\>path

> PATH=C:\WINDOWS\system32C:\WINDOWSC:\WINDOWS\System32\WbemC:\Program

> Files\

>

> Ex

> ecutive Software\Diskeeper\C:\Program Files\Microsoft SQL

> Server\80\Tools\

> Binn\

> C:\Program Files\Microsoft SQL Server\90\Tools\binn\C:\Program Files\

> Microsoft

> SQL Server\90\DTS\Binn\C:\Program Files\Microsoft SQL

> Server\90\Tools\Binn\

> VSS

> hell\Common7\IDE\C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\

> Private

> Assemblies\

>

> H:\>

>

> --

> Message posted via WinServerKB.com

> http://www.winserverkb.com/Uwe/Forums.aspx/windows-2000-general/201003/1

>

 

[Greg Russell]

In news:O4lABUXwKHA.812@TK2MSFTNGP06.phx.gbl,

Dave Patrick typed:



> What happens if you do a

> bcp /?

> from a cmd.exe session?



I give up ... what?



Why do you even ask for help?



Try quoting what you're responding to next time, dipwad.

 

[John John - MVP]

Greg Russell wrote:

> In news:O4lABUXwKHA.812@TK2MSFTNGP06.phx.gbl,

> Dave Patrick typed:

>

>> What happens if you do a

>> bcp /?

>> from a cmd.exe session?

>

> I give up ... what?

>

> Why do you even ask for help?

>

> Try quoting what you're responding to next time, dipwad.



If you can't follow the train of discussion please refrain from posting,

you are utterly lost in as little as the exchanges of two postings...

 

[dashary via WinServerKB.com]

I tried your suggestion and I got a login/error:



SQLState = 28000, NativeError = 18456

Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user.



This may be a security issue with the server?



Dave Patrick wrote:

>What happens if you do a

>

>bcp /?

>

>from a cmd.exe session?

>

>>I am running the bcp utility under Microsoft Visual studio 2005 and receive

>> the following in the progress log:

>[quoted text clipped - 39 lines]

>>

>> H:\>



--

Message posted via WinServerKB.com

http://www.winserverkb.com/Uwe/Forums.aspx/windows-2000-general/201003/1

 

[Greg Russell]

In news:OS88K5ewKHA.2436@TK2MSFTNGP04.phx.gbl,

John John - MVPig typed:



> If you can't follow the train of discussion please refrain from

> posting,



Why don't *you* refrain from top-posting, moron? At least you did so above,

so it's possible for you to learn something.

 

[John John - MVP]

Greg Russell wrote:

> In news:OS88K5ewKHA.2436@TK2MSFTNGP04.phx.gbl,

> John John - MVPig typed:

>

>> If you can't follow the train of discussion please refrain from

>> posting,

>

> Why don't *you* refrain from top-posting, moron? At least you did so above,

> so it's possible for you to learn something.



You're quite a clown, aren't you? If it's possible to learn something

then maybe you can learn how to be civil, but I have a feeling that you

are one of those who can't learn civility and who thinks that insulting

others in usenet groups is a smart thing to do. Do you actually talk to

people face to face as you do in these newsgroup exchanges? Just

because you are an anonymous figure hiding behind a keyboard don't

forget that these groups are made up of real human beings and they

deserve to be treated with respect as they would be treated in a face to

face conversation, or maybe you are also a jerk in your daily

interactions with others in your entourage. And as for top/bottom

posting if it bothers you then killfile me and be done with it, I'll

post wherever I want and I won't cry if you don't read my posts.



John

 

[Greg Russell]

In news:%23myZV6gwKHA.404@TK2MSFTNGP02.phx.gbl,

John John - MVP typed:



>> Why don't *you* refrain from top-posting, moron? At least you did so

>> above, so it's possible for you to learn something.

>

> If it's possible to learn something then maybe ...



See? You're doing better all the time.

 

[John John - MVP]

Posted up here on purpose. You forgot Rule 1 of netiquette... if you

ever even knew what it is, which I doubt.





Greg Russell wrote:

> In news:%23myZV6gwKHA.404@TK2MSFTNGP02.phx.gbl,

> John John - MVP typed:

>

>>> Why don't *you* refrain from top-posting, moron? At least you did so

>>> above, so it's possible for you to learn something.

>> If it's possible to learn something then maybe ...

>

> See? You're doing better all the time.

>

>

 

[Greg Russell]

In news:uJGMqlhwKHA.4552@TK2MSFTNGP04.phx.gbl,

John John - MVP typed:



> Posted up here on purpose.



Up where? Your ass is where it belongs.

 

[John John - MVP]

As it is plainly obvious that you are nothing more than a troll wanting

to steer the conversation in a certain direction I will now follow rule

no. 7 of netiquette and stop contributing to the thread. Have fun and

good luck with your endeavours.







Greg Russell wrote:

> In news:uJGMqlhwKHA.4552@TK2MSFTNGP04.phx.gbl,

> John John - MVP typed:

>

>> Posted up here on purpose.

>

> Up where? Your ass is where it belongs.

>

>

 

[Greg Russell]

In news:eUl5IXiwKHA.3764@TK2MSFTNGP04.phx.gbl,

John John - MVPig typed:



> I will now ... stop contributing to the thread.



Such drama ...

 

[Dave Patrick]

Try reading here noodle nuts.



http://www.microsoft.com/communitie...423-8e95-f2050920b5e5&lang=en&cr=us&sloc=&p=4







--



Regards,



Dave Patrick ....Please no email replies - reply in newsgroup.

Microsoft Certified Professional

Microsoft MVP [Windows]

http://www.microsoft.com/protect



"Greg Russell" wrote:

> I give up ... what?

>

> Why do you even ask for help?

>

> Try quoting what you're responding to next time, dipwad.

 

[Dave Patrick]

Maybe this one helps.



http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/b450937f-0ef5-427a-ae3b-115335c0d83c









--



Regards,



Dave Patrick ....Please no email replies - reply in newsgroup.

Microsoft Certified Professional

Microsoft MVP [Windows]

http://www.microsoft.com/protect



"dashary via WinServerKB.com" wrote:

>I tried your suggestion and I got a login/error:

>

> SQLState = 28000, NativeError = 18456

> Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user.

>

> This may be a security issue with the server?

 

[Greg Russell]

"Dave Patrick" wrote in message

news:ek7gnYmwKHA.5936@TK2MSFTNGP04.phx.gbl...



> Try reading here



Where?

 

[Peter]

"Greg Russell" wrote in message

news:800l08F6ctU1@mid.individual.net...

> "Dave Patrick" wrote in message

> news:ek7gnYmwKHA.5936@TK2MSFTNGP04.phx.gbl...

>

>> Try reading here

>

> Where?



Sheesh... you're a tool but you aren't exactly the sharpest tool in the

shed!

 

[Greg Russell]

"Peter" wrote in message

news:CGSmn.18268$ND2.2222@newsfe05.iad...



> Sheesh... you're a tool



What does sex have to do with anything?