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.