Feb-03-2017, 05:52 PM
(Feb-03-2017, 05:47 PM)buran Wrote: In the same time when usingwith
pymssql returns connection and I have to get cursor myself.
I know because I have to work simultaneously with MySQL and MSSQL
Gross. I checked the pep for what db drivers are supposed to do as a context manager, and it didn't mention them at all, before I made my last comment.
ANYWAY. So you CAN make other queries just fine, right? It's just this one particular one isn't working? Is there a special way to do multi-statements?
What happens if you do something much simpler, like a double-select?
select curdate(); select curdate();Do you get two result rows, or an error parsing the query?