Reuse of DB-API 2.0 cursors for multiple queries?

[Дамјан Георгиевски]

> Today, I used the adodbapi module against an SQL Server Express
> database. I was surprised to get an exception, when I attempted to
> submit a second query with my cursor object. The full session is
> below.

>>> curs.execute('select * from localview_roles')
>>> curs.execute('select * from localview_roles')

have you tried to curs.fetch() or fetchall() before the second execute?



-- 
дамјан ( http://softver.org.mk/damjan/ )

Scarlett Johansson: You always see the glass half-empty.
Woody Allen: No. I see the glass half-full, but of poison.