Invalid Cursor State Error - Not Solved

[Puneet13]

While testing the connection in SQL Editor it is showing "A successful connection was made and no errors were found parsing the query". However while running in Alteryx it is showing "Cursor State Error", i have seen many solution in Community but no one able to solved this problem. I have attached the snapshot for the reference.

[patrick_mcauliffe]

Can you run the exact same SQL statement in another tool?  Like SSMS?

[Ariharan]

Hi @Puneet13 , 

I faced this same error before and adding "BEGIN" at the beginning of the query and adding "NOCOUNT ON END" at the end of the query solved my problem.

BEGIN
/*Your Query*/
SET NOCOUNT ON
END

Regards, 

Ariharan R