I'm having the same issue, and frequently. Has any new information come up on this bug?
It happens with a "SELECT count(*) from <table>". Its occurrence is influenced by other statements executed earlier in the program, so it's hard to come up with a small test case.
It happens with pyodbc 2.1.11 and pyodbc 3.0.6, both on python 2.6