Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hello, I'm trying to use the <https://docs.prefect.io/integrations/prefect-sqlalchemy/index|SqlAlchemyConnector integration> and my question is if anyone is successfully using <https://prefect-python-sdk-docs.netlify.app/prefect_sqlalchemy/database/#prefect_sqlalchemy.database.SqlAlchemyConnector.fetch_all|fetch_all(), fetch_many(), or fetch_one()> with a database on ms sql server.

I'm using the pyodbc driver on the SqlAlchemyConnector.  I've tried both the ODBC driver 17 and 18.  Regardless of which of these drivers I use, I get an exception thrown that originates form the driver.  The message is `Function sequence error (0) (SQLFetch) HY010`.  Seems to be an issue with the <https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlfetch-function?view=sql-server-ver16|order of commands>.