[DB-SIG] adodbapi

[Jonathan Franz]

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.
> 
> 
>