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

Are there any known issues with `pyodbc`? I keep running into `pyodbc.ProgrammingError: No results.  Previous SQL was not a query.`

I'm getting a crash, which ends up hanging the terminal. On my Windows laptop I must close the terminal as `Ctrl+C` does nothing (on Linux I get an even longer trace).

I have been able to reproduce with a minimal ~30 line example. Here is the example code, it's output, as well as the longer trace from my full program: <https://gist.github.com/ZachMassia/efe79e6853afdf20b367ff5bbd2825f3>

Thanks in advance if anyone can point me in the right direction!

Some extra info, from playing around with the sample a bit I've discovered that if I remove the task decorator from the query_db function, all works (even if there is a flow, and the connection fn is a task)

By pure luck I've got it working!

I don't know if this is a Prefect or PyODBC issue, but it seems that passing around the connection, instead of a cursor, fixes everything. :man-shrugging:

```@task
def query_db(con):
    print('Querying DB')
    results = con.cursor().execute('select top (1) * from raw.TRUCK').fetchall()
    return results```
