“Function sequence error” in bcp with xp_cmdshell
May 9th, 2007 — ¥ong¥s
Free Link Exchange Software and Automate Link Swap Service
Offers free link swap service, link trade directory, reciprocal link exchange software that auto updates your link pages and complete link exchange. |
Do you ever get “Function sequence error” when running bcp with xp_cmdshell? The stored procedure executed fine.
SQLState = HY010, NativeError = 0
Error = [Microsoft][SQL Native Client]Function sequence error
NULL
I am not sure my solution can 100% solve the error, but it works in my machine. The trick is to turn on “Database Mail (Enable database stored procedures)” in “Surface Area Configuration for Features”. Try to run again and the error will gone!
*You may encounter this error while testing on the sample in “How to import multiple CSV files using MS SQL store procedure?“
August 17th, 2008 at 12:39 pm
[...] = HY010, NativeError = 0 Error = [Microsoft][SQL Native Client]Function sequence error NULL Read the rest of this entry (moved to http://www.bronios.com) » Posted in [...]