[DB-SIG] MSAccess

[William Dode]

hi,

Even if it's not interesting to make a DB-API on top of ADO, i could
use ADO alone. But i try it and found that it's very very slow when
i compare to odbc of winext or mxodbc... Any idea ?

For mxodbc, there is a problem with the licence not compatible with
GNU/GPL. Even not open source, it break all the strategie of using
other open source products.

bye


Le Thu, 6 Jun 2002 22:05:17 -0400
"Michel Orengo" <morengo@nyc.rr.com> écrivait:

> """
> if you found it useful. Looks like it never got finished.
> """
> No it never got finished because I had to switch to more important (and
> lucrative ;-) things
> 
> Using ADO with the *excellent* COM interface from Mark Hammond is a
> piece of cake. The issue is MS documentation. I have started this
> project by encapsulating (an attempt to simplify) some ADO objects.
> Mark H. correctly so demonstrated the limits of my approach, and
> suggested I'd rather spend my time building a compatible DB-API for ADO.
> That was my first and final trial.
> 
> Looking back on this, I am not sure there is a lot of value in having a
> DB-API on top of ADO: the DB-API is somewhat too "low-level" for ADO. I
> consider DB-API being a more abstract ODBC. ADO sits on top of ODBC (and
> other drivers too.)
> 
> If a common Python API existed for OO-access-to-DB, then implementation
> of this API using ADO would make sense.
> 
> Regards,
> 
> Michel
> 
> 
> -----Original Message-----
> From: db-sig-admin@python.org [mailto:db-sig-admin@python.org]On Behalf
> Of Gerhard Häring
> Sent: Thursday, June 06, 2002 12:35 PM
> To: db-sig@python.org
> Subject: Re: [DB-SIG] MSAccess
> 
> 
> * William Dode <wilk@flibuste.net> [2002-06-06 16:26 +0200]:
> > I found a page about ADO http://www.e-coli.net/pyado.html, it seems
> > to work well also... i think it could be easy to make a DB2api
> > around it isnt'it ?
> 
> Relatively easy, but it's some work to make it DB-API compliant. We're
> currently experiencing that in the PySQLite project: it's relatively
> easy to get something out the door, but a lot more work lies in the
> refinements.
> 
> Btw. I've saved the following email that I could send you:
> 
> From: Michel Orengo <morganea@bellatlantic.net>
> To: python-list@python.org
> Subject: [ANN]pre-release DBAPI2.0 for ADO
> Date: Wed, 5 Jul 2000 13:26:41 -0500
> X-Mailer: Internet Mail Service (5.5.2653.19)
> 
> if you found it useful. Looks like it never got finished.
> 
> Gerhard
> --
> mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
> web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id
> AD24C930 public key fingerprint: 3FCC 8700 3012 0A9E B0C9  3667 814B
> 9CAA AD24 C930 reduce(lambda x,y:x+y,map(lambda
> x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))
> 
> 
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig
> 
> 
> 
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig
> 


-- 
William Dodé - Informaticien Indépendant
http://www.flibuste.net