python ADO DB API gives MS SQL cursor engine out of memory error. What is an alternative to python ado db api?
<p>I am currently using python with adodb api for MS Sql database connection. This is working very well for smaller databases. But for large databases when the query is returning huge data, I get MS Sql cursor out of memory error. This works fine with Server side cursor. But then it consumes lot of memory on my server.</p>
<p><strong>Question 1</strong>: How can I continue to use client side cursor? Can reading data in chunks be an option?</p>
<p><strong>Question 2</strong>: Is there any alternative to python ado db API?</p>
<p>I searched for other options to connect to MS Sql. Found this link about comparison  - <a href="https://stackoverflow.com/questions/8812631/pymssql-versus-pyodbc-versus-adodbapi-versus">pymssql versus pyodbc versus adodbapi versus...</a>. This looks old information. I have started my own investigation with pyodbc and pymssql.</p>
<p>Can anybody recommend which is better out of these?</p>