On Thursday, March 25, 2010 09:11 PM, JohnS wrote: > > On Thu, 2010-03-25 at 14:14 +0800, Christopher Chan wrote: >> Is it me or does the MySQLdb module in Centos not support python's DBAPI >> 2.0 > > --- > Well you give no clue to the code your using. Post what type your > using, > > It uses cursors so it it is compliant as far as I see. > > I get you installed it and it is dbapi 2. > > What does your python code look like? The same as everything below except for the initialize() call. > > db = MySQLdb.connect (dsn='192.168.0.1:your_db', > user='root', password='password') > ########################## > def addEntry(names): > > cursor.initialize() > cursor = db.cursor () > ########################### > > I think a good idea would be to drop it and go to postgres, and import > pgdb. I would love to were it not for the fact that one of the target clients runs OpenSolaris and does not package a postgresql module for python. Grr... Thanks, I will give this another shot before I give up on learning python and go back to perl or php land.