On 6/5/07, Joe <[EMAIL PROTECTED]> wrote: > > > > > >File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line > 147, in execute > > > charset = db.character_set_name() > > > > > >InterfaceError: (0, '') > > > > We got it working. It was caused by passing a database connection to a > module: > > > > import MySQLdb > > import module_name > > connection = MySQLdb.connect(host='localhost', user='user', > passwd='password', db='database') > > module = module_name.ClassName(connection) > > > > But, when the connection was made within the module itself, it would work > flawlessly every time. Can someone explain to me why this is? > > > > Jough > -- > http://mail.python.org/mailman/listinfo/python-list >
Try passing the cursor and not the connection - import MySQLdb import module_name connection = MySQLdb.connect(host='localhost', user='user', passwd='password', db='database') cursor = connection.cursor() module = module_name.ClassName(cursor) You'll probably have to modify the module's code a bit as well, but it should work. -- http://mail.python.org/mailman/listinfo/python-list