BCP Vague error

[kumar]

Hi,
System info:
Windows 2000 enterprise edition
Sql 2000 enterprise edition.
I am trying to run 'bcp' using 'xp_cmdshell' in query analyser, it gives an error ..
"BCP" is not a recognized internal or external command.
Then I checked using command line commands like dir, ipconfig, they all work fine.
But when I checked the xp_cmdshell 'Path', output is null.
I verified BCP is fine by running directly using DOS.
Rebooted system, but the result is same.
If any of you have solution to this problem, let me know
Thanks in advance.
Kumar

[Andraax]

Make sure to enter the entire path to the BCP.EXE file. Should work then.


------------
kumar at 8/30/01 2:25:07 PM

Hi,
System info:
Windows 2000 enterprise edition
Sql 2000 enterprise edition.
I am trying to run 'bcp' using 'xp_cmdshell' in query analyser, it gives an error ..
"BCP" is not a recognized internal or external command.
Then I checked using command line commands like dir, ipconfig, they all work fine.
But when I checked the xp_cmdshell 'Path', output is null.
I verified BCP is fine by running directly using DOS.
Rebooted system, but the result is same.
If any of you have solution to this problem, let me know
Thanks in advance.
Kumar