Switching Databases

[Carsten Haese]

Victor Subervi wrote:
> Hi;
> I have the following code:
> 
> import MySQLdb
> ...
> user, passwd, db, host = login()
> db = MySQLdb.connect(host, user, passwd, 'cart')
> cursor= db.cursor()
> ...
> cursor.close()
> db = MySQLdb.connect(host, user, passwd, db)
> cursor= db.cursor()
> 
> Now, python complains about me opening a new connection.

Do not paraphrase error messages. Copy and paste the actual error
message and traceback.

> But I thought
> I'd closed the first one!

You thought you did, but did you? The code snippet above doesn't show
any code that closes a database connection.

> So, I replaced the last 3 lines with this:
> 
> cursor.execute('use %s;' % db)
> 
> but it didn't like that, either.

Do not paraphrase error messages. Copy and paste the actual error
message and traceback.

--
Carsten Haese
http://informixdb.sourceforge.net