bcp.exe installation

(This was originally in the sqlserver.programming group but I moved it to a
more appropriate place)
I'm using the bcp utility to create a text file from a view. The text file
is used by a 3rd party program for other processing.
bcp installs on the server machine with sql 2k (or in my case MSDE) just
fine but of course it's not automatically on any of the client machines. But
that's where I need it because those are the users that create and make use
of this text file.
My qustion is how to install bcp on the client machines without installing
MSDE. I thought it would work to just copy the file to an appropriate
location but apparently it needs to be installed. How do I go about that?
Thanks,
Keith
Never mind. I found a very nice inexpensive 3rd party control for use with
Delphi that will export datasources to all sorts of output formats. This is
a better solution since now I have no need at all for bcp.
Keith

BCP SQLSTATE = S1010

Good afternoon.
I have encountered an error in BCP that I originally never had. I have
not made any changes to the system, however, the BCP utility fails.
I am running the following statement:
bcp "Select * from Database..View" queryout "C:\Export\infile.txt" -U
user -P Password -f "C:\Formatfile\infile.fmt"
Resulting in the following error:
SQLSTATE = S1010, Native Error = 0
Error = [Microsoft][ODBC SQL Server Driver]Function Sequence Error
Background Info:
SQL Server 2000 SP3 (8.00.818)
Thanks!
Nathan
Hi Nathan,
Are other users modifying data when you execute the bcp command ?
If so, then there may be a Deadlock scenario and to over come it, just try
doing an Uncommited read in the BCP command, by adding "with (Nolock)" in
the select statement.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

BCP SQLSTATE = S1010

Good afternoon.
I have encountered an error in BCP that I originally never had. I have
not made any changes to the system, however, the BCP utility fails.
I am running the following statement:
bcp "Select * from Database..View" queryout "C:\Export\infile.txt" -U
user -P Password -f "C:\Formatfile\infile.fmt"
Resulting in the following error:
SQLSTATE = S1010, Native Error = 0
Error = [Microsoft][ODBC SQL Server Driver]Function Sequence Error
Background Info:
SQL Server 2000 SP3 (8.00.818)
Thanks!
NathanHi Nathan,
Are other users modifying data when you execute the bcp command ?
If so, then there may be a Deadlock scenario and to over come it, just try
doing an Uncommited read in the BCP command, by adding "with (Nolock)" in
the select statement.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

BCP SQLSTATE = S1010

Good afternoon.
I have encountered an error in BCP that I originally never had. I have
not made any changes to the system, however, the BCP utility fails.
I am running the following statement:
bcp "Select * from Database..View" queryout "C:\Export\infile.txt" -U
user -P Password -f "C:\Formatfile\infile.fmt"
Resulting in the following error:
SQLSTATE = S1010, Native Error = 0
Error = [Microsoft][ODBC SQL Server Driver]Function Sequence Error
Background Info:
SQL Server 2000 SP3 (8.00.818)
Thanks!
NathanHi Nathan,
Are other users modifying data when you execute the bcp command ?
If so, then there may be a Deadlock scenario and to over come it, just try
doing an Uncommited read in the BCP command, by adding "with (Nolock)" in
the select statement.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.