[python-sybase] MemoryError using Sybase, FreeTDS, MS SQL

[Valerie R. C. <vr...@co...>]

Hi,

I'm getting Memory Errors with very simple queries using Python-Sybase 
0.35 and the latest FreeTDS to connect to a MS SQL server.  Is this a 
problem with FreeTDS?  Will Kevin's patch (from an earlier thread) fix 
my problem?  Or is there a problem with my code?  

Here is the code:

import Sybase
db = Sybase.connect(SERVER, USER, PASSWORD, DATABASE)
db.execute("SELECT * FROM FEMMD_Parameters WHERE MDregionSize = 10")

The table isn't that huge, maybe 100 rows or less.  Anyway, I get the 
same error whether or not I include a condition that would select only a 
few lines.  It might also help if I mention that I'm telling FreeTDS to 
use version 7.0 in the freetds.conf file.

Here is the Traceback:

Traceback (most recent call last):
  File "DBTest.py", line 10, in ?
    db.execute("SELECT * FROM FEMMD_Parameters WHERE MDregionSize = 10")
  File 
"/afs/.msc.cornell.edu/i386_linux22/usr/local/pub/dm/lib/python2.1/site-packages/Sybase.py", 
line 727, in execute
    result_list = self._fetch_results()
  File 
"/afs/.msc.cornell.edu/i386_linux22/usr/local/pub/dm/lib/python2.1/site-packages/Sybase.py", 
line 745, in _fetch_results
    bufs = _row_bind(cmd, self.arraysize)
  File 
"/afs/.msc.cornell.edu/i386_linux22/usr/local/pub/dm/lib/python2.1/site-packages/Sybase.py", 
line 159, in _row_bind
    status, buf = cmd.ct_bind(i + 1, fmt)
MemoryError

Thanks a lot,
Valerie