SQL error, please help - "Invalid Cursor State"

[mattd17]

Trying to pull monthly data for a portfolio, I have 600k+ rows on 30+ fields. ODBC connection seems fine, but when importing the code I get the following errors - looks like it might be a memory management issue? Would appreciate the help from anyone. (Blacked out server names)

[hhart]

Thank you - this worked for me as well!

[Rob_Sheehan]

I've also found that inadvertently leaving "use..."  in your SQL will cause this "Invalid Cursor State" msg as well in Alteryx.

We really don't need it there since it will be defined in local ODBC driver.

USE ABC_DATABASE

SELECT...

[TJM686]

I had the same error due to the USE DATABSE command in my SQL. Removing it from the query and setting a default database in the ODBC configuration resolved the issue for me.