Press "Enter" to skip to content

PyODBC Error Messages

Jose Manuel Jurado Diaz collects a compendium of errors:

1) pyodbc.Error: (‘HY000’, ‘[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)’)

This error ocurrs when the Python code is trying to open a new cursor when we have a previous one with results. 

Read on for examples of the problem and solutions for each.