jfranz at neurokode.com
Mon Apr 25 19:36:31 CEST 2005
Ouch, that is nasty, did you end up having to use two connections?
The bug I found, and fixed was with transaction handling. The current
adodbapi looks at a property on the underlying ADO connection to
determine if transactions are supported. Unfortunately, it just looks
for the presence of that property, not the value of the property. Thus,
when using the DBF driver adodbapi raises errors because it tries to
call BeginTrans on the ADO connection. The fix was clean and simple -
just use the value of the property if the property exists.
Chris Curvey wrote:
> Trying to remember, I gave up so long ago....
> IIRC, I think that I was unable to get two cursors from the same
> connection at the same time. Which meant I had to be really careful
> when designing tranasctions. I think I looked at the source code to try
> to fix it, but it was something architectural about the design of the
> library that prevented me from suggesting a fix.
More information about the DB-SIG