what is Error = [Microsoft][SQL Server Native Client 10.0]Function sequence error?

Question

1.00/5 (1 vote)

See more:

I am executing below bcp query but receiving error..please help me out ..

SQL

EXEC master..xp_cmdshell 'bcp "select f.C_EmpNo as EmpCode,f.C_Name as FSName,ua.N_Type as NType,ua.c_sh_name as Desg, ui.C_UserID as UserID,dwr.dcrcount as DCR_Count from  VESTASLIFE..Tbl_FS_Mst f  join VESTASLIFE..Tbl_User_Access ua on f.N_Type=ua.N_Type  join VESTASLIFE..Tbl_User_Info ui on f.C_EmpNo=ui.C_Code left join (select c_fs_code,COUNT(distinct n_srno) as dcrcount   from VESTASLIFE..tbl_dwr d  where  MONTH(d.D_Date_Report)=7 and YEAR(d.D_Date_Report)=2015      group by c_fs_code )dwr on dwr.C_FS_Code=f.C_Code where f.C_EmpNo<>''000000'' or dwr.dcrcount is not null --and  dwr.dcrcount=null order by f.C_EmpNo,f.N_Type,f.C_Name " queryout D:\VESTASLIFE\usercountdetails.txt -S GGSFADATA -T -t -c '

error in below..

Error = [Microsoft][SQL Server Native Client 10.0]Function sequence error

Posted 27-Jul-15 19:03pm

Member 11337367

Updated 27-Jul-15 19:16pm

Suvendu Shekhar Giri

v2

Add a Solution

Comments

Wendelius 28-Jul-15 1:44am

Have you tried with a simple SQL statement, such as

SELECT 1

ZurdoDev 28-Jul-15 7:27am

A quick google search of error indicates you have something wrong (yes, I know that's obvious.) You'll have to start narrowing it down and really look at closely each parameter. You may have misspelled a table or db or something.

[no name] 8-Sep-16 10:32am

try that exec with a simple sql like select 1
if it work's test your query
if not have a look at those params
-S mising computer name
-t replace \t with ?
https://msdn.microsoft.com/en-us/library/ms162802.aspx

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)