I think it's an ODBC error rather than SQL Server. Perhaps you've got
an issue with the order in which ODBC calls are being made.

- Kevin

-----Original Message-----
From: Nathan Dosmann [mailto:[Email Address Removed]
Sent: Wednesday, May 12, 2004 11:28 AM
To: LazyDBA.com Discussion
Subject: Function Sequence Error

Good afternoon.

I have encountered an error in BCP that just appeared for no apparent
reason. 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)

Any ideas why this would be??

Thanks!
Nathan

--
*******************************************
Nathan Dosmann
Database Systems Engineer

*******************************************



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page