Hello. I'm new to the world of Python database access. I've read the DB-API documents and find the 2.0 version pretty nice. However, for my current work I have to access a local .mdb file.
I've already been able to do it with the pywin32 odbc module, which AFAIK it conforms to the DB-API 1.0. I've found adodbapi, which says it is 2.0, but it fails with huge fireworks trying to access tables with binary objects (something about COM objects being unknown), so I can't use it. I've tried contacting the author but I'm waiting for any answer. Is it right that there is no other MS Access python module? I guess I'll have to use odbc then. Also, the DB-API 2.0 spec says several things about yet to be solved issues, like loss-less currency types and such. Is there anywhere a roadmap about this? Is a DB-API 3.0 in the works? I've tried contacting the webmaster at python.org to tell that there's no link for adodbapi and the odbc documentation/hint links are borken, but have received no answer. Also, I've found http://adodb.sourceforge.net/ not listed on those pages. It says it should work with access through odbc. Has somebody tried this with success? The python documentation mentions that it has to drift from the DB-API 2.0 spec due to limitations in how rows are retrieved. Is this some sort of big split in the Python database community? I mean, is this going to be addressed by a future PEP or are people leaving DB-API 2.0 in favor of the adodb api? -- Grzegorz Adam Hankiewicz, Jefe de producto de TeraVial Rastertech España S.A. Tel: +34 918 467 390, ext 18. http://www.rastertech.es/ [EMAIL PROTECTED] _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
