Closed infinitewarp closed 7 years ago
I don't know what has changed, but I'm not seeing this error any more. Maybe there was something else funky on my network or SQL Server instance that was somehow borking my connections in a weird way. ¯\_(ツ)_/¯
This appears to be a duplicate of #37, but since that issue is closed and doesn't appear to be getting any attention, here I am. If someone reopens #37 and provides a real fix, please close this. 🎉
Using a recent version of master from github source newer than the release in pypi is supposed to resolve this issue, but I intermittently get this error from pytds:
Usually the first few operations (selects, inserts, deletes) to the database succeed, but sometimes unpredictably a random subsequent operation will fail with that error.
I've tried setting an arbitrarily large
login_timeout
value (currently at1200
) on the connect call (as a possible fix suggested in #37), but that doesn't seem to make any difference.Also, it shouldn't make any difference, but I'm establishing the connection and cursors as context managers like this: