[python-sybase] MemoryError using Sybase, FreeTDS, MS SQL
Valerie R. Coffman
vrc3 at cornell.edu
Fri, 17 Jan 2003 13:00:49 -0500
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