Re: [DB-SIG] Reuse of DB-API 2.0 cursors for multiple queries?

2009-01-29 Thread M.-A. Lemburg
On 2009-01-29 22:05, Andy Todd wrote: > M.-A. Lemburg wrote: >> On 2009-01-29 21:15, Alex Willmer wrote: >>> (Reposted to DB-SIG from clp) >>> >>> This week, I used the adodbapi module against an SQL Server Express >>> database. I was surprised to get an exception, when I attempted to >>> submit a

Re: [DB-SIG] Reuse of DB-API 2.0 cursors for multiple queries?

2009-01-29 Thread Andy Todd
M.-A. Lemburg wrote: On 2009-01-29 21:15, Alex Willmer wrote: (Reposted to DB-SIG from clp) This week, 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 bel

Re: [DB-SIG] ANN: eGenix mx Base Distribution 3.1.2

2009-01-29 Thread eGenix Team: M.-A. Lemburg
On 2009-01-29 19:25, Vernon Cole wrote: > Dear eGenix Team: > import mx.DateTime import datetime md = mx.DateTime.Timestamp(1950,6,12,12,30,0) dd = datetime.datetime(1950,6,12,12,30,0) if md == dd: print 'It works!' > ... > It works! > > Thank you on behalf of adodbapi u

Re: [DB-SIG] PEP 249 in obsolete for Python 3000

2009-01-29 Thread M.-A. Lemburg
On 2009-01-29 20:15, Vernon Cole wrote: > I am busy hacking on code in an attempt to make adodbapi actually work in > three environments: CPython 2.3 to 2.6, CPython 3.0, and IronPython. One of > the first things that failed, when attempting to run on Python 3.0, was the > test for exception defini

Re: [DB-SIG] Reuse of DB-API 2.0 cursors for multiple queries?

2009-01-29 Thread M.-A. Lemburg
On 2009-01-29 21:15, Alex Willmer wrote: > (Reposted to DB-SIG from clp) > > This week, 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. > > Wit

[DB-SIG] Reuse of DB-API 2.0 cursors for multiple queries?

2009-01-29 Thread Alex Willmer
(Reposted to DB-SIG from clp) This week, 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. With cx_Oracle I've become used to reusing a cursor for subs

[DB-SIG] PEP 249 in obsolete for Python 3000

2009-01-29 Thread Vernon Cole
I am busy hacking on code in an attempt to make adodbapi actually work in three environments: CPython 2.3 to 2.6, CPython 3.0, and IronPython. One of the first things that failed, when attempting to run on Python 3.0, was the test for exception definitions. I quote: The module should make all err

Re: [DB-SIG] ANN: eGenix mx Base Distribution 3.1.2

2009-01-29 Thread Vernon Cole
Dear eGenix Team: >>> import mx.DateTime >>> import datetime >>> md = mx.DateTime.Timestamp(1950,6,12,12,30,0) >>> dd = datetime.datetime(1950,6,12,12,30,0) >>> if md == dd: print 'It works!' ... It works! Thank you on behalf of adodbapi users everywhere who's programs will no longer mysteriousl

[DB-SIG] ANN: eGenix mx Base Distribution 3.1.2

2009-01-29 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mx Base Distribution Version 3.1.2 for Python 2.3 - 2.6 Open Source Python extensions providing important and useful services