Hello, I'm trying to use the <SqlAlchemyConnector ...
# prefect-integrations
a
Hello, I'm trying to use the SqlAlchemyConnector integration and my question is if anyone is successfully using 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 order of commands.