ADO error - large data set
gygulyas at gmail.com
Wed Mar 19 17:14:49 CET 2008
I have been running Python to tap into an MS Access 2003 database
using ADO (PythonWin+COM). Everything works great creating recordsets
etc. when I open a table with a small number of records. However, when
I try to run the same Python code with a large table (>100,000) I get:
Traceback (most recent call last):
\scriptutils.py", line 310, in RunScript
exec codeObject in __main__.__dict__
File "C:\Documents and Settings\user\Desktop\PythonWS\scripts
\readmsaccess.py", line 43, in <module>
rs.Open('SELECT * FROM ' + tblname, oConn, 1, 3)
D9EB-4129-B803-931327F72D5Cx0x2x8.py", line 2364, in Open
, ActiveConnection, CursorType, LockType, Options)
com_error: (-2147352567, 'Exception occurred.', (0, None, None, None,
5003251, -2147467259), None)
The small and large table structures are identical, all I do is change
the tblname from input1000 (1000 records) to input (>100000 records).
I use optimistic locking and keyset cursor..nothing out of the
Any ideas? ADO 2.8 is what I am using.
Thanks a lot!
More information about the Python-list