[DB-SIG] MSAccess

[Michel Orengo]

"""
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 suggeste=
d
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 o=
f
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=E4ring
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 AD24C93=
0
public key fingerprint: 3FCC 8700 3012 0A9E B0C9  3667 814B 9CAA AD24 C93=
0
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