Is there any way can make me using python with mysql on win32
store_li at sina.com
Sun Jan 6 20:58:59 CET 2002
Thank you! I got it. It is now running on my machine. But mxODBC still won't
work for me on mysql. While,...it really can get well with SQL 7.0.
"Gerhard Häring" <gh_pythonlist at gmx.de> wrote in message
news:mailman.1010295129.7002.python-list at python.org...
> Le 06/01/02 à 11:17, Kick écrivit:
> > I have tried odbc, but the odbc.odbc function don't allow me transfer
> > and password to mysql and mx.ODBC.Windows.Connect raised a error
> > "[TCX][MySQL] doesn't support transaction"
> > What shall I do?
> I'm sure it's possible with ODBC, but I'd just scrap mxODBC and use
> MySQLdb instead (if only because I know it better); it's a DB-API 2.0
> Python database for MySQL.
> Get it here: http://www.sf.net/projects/mysql-python
> You can get Windows installers for Python versions from 1.5.2 up to 2.2.
> Then, build a connection with
> import MySQLdb
> con = MySQLdb.connect(host="somehost", user="someuser",\
> passwd="somepwd", db="dbname")
> mail: gerhard <at> bigfoot <dot> de registered Linux user #64239
> web: http://www.cs.fhm.edu/~ifw00065/ OpenPGP public key id 86AB43C0
> public key fingerprint: DEC1 1D02 5743 1159 CD20 A4B6 7B22 6575 86AB 43C0
> reduce(lambda x,y:x+y,map(lambda
More information about the Python-list