Invalid Cursor State Error - Not Solved

Question

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.

Error.JPG

Successful Connection in SQL.JPG

Ariharan · Answer

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

patrick_mcauliffe · Answer

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