“Function sequence error” in bcp with xp_cmdshell
May 9th, 2007 — ¥ong¥s
Online project management, task software, and free collaboration workspace: AJAXWorkspace
AJAXWorkspace is a free online workspace that offers task tracking software, team collaboration, online calendar, document sharing, and file management for project management and teamwork. |
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 [...]