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.
_______________________________________________ DB-SIG maillist - [email protected] http://mail.python.org/mailman/listinfo/db-sig
