[Zope-DB] using mxODBC and mySQL to connect with Zope

Laura McCord Laura.McCord at doucet-austin.com
Tue Apr 20 13:30:13 EDT 2004


I already have ZMySQLDA installed and I have it working. But, I needed
to install mxODBC to connect with my SQL server. I understand that
mxODBC handles MySQL as well so I feel like I should just use mxODBC and
kill two birds with one stone instead of having multiple database
connectors. If mxODBC can handle all of my databases then I should just
use mxODBC.

-Laura

-----Original Message-----
From: Bobb [mailto:rawbobb at hotmail.com] 
Sent: Tuesday, April 20, 2004 12:31 PM
To: Charlie Clark; Laura McCord
Cc: zope-db at zope.org
Subject: Re: [Zope-DB] using mxODBC and mySQL to connect with Zope


IMO, you don't want to use ODBC to connect to mysql (it's one of those
why bother thingies) no need. (ZMySQLDA)
----- Original Message -----
From: "Charlie Clark" <charlie at egenix.com>
To: "Laura McCord" <Laura.McCord at doucet-austin.com>
Cc: <zope-db at zope.org>
Sent: Tuesday, April 20, 2004 1:11 PM
Subject: Re: [Zope-DB] using mxODBC and mySQL to connect with Zope


> Hi Laura,
>
> you can either use the ZMySQLDA with the Python MySQL driver or use 
> mxODBC to talk to the the MySQL-ODBC driver.
>
> Regards
>
> Charlie
> On 2004-04-20 at 18:55:10 [+0200], Laura McCord wrote:
> > I have successfully linked a SQL Server using mxODBC with Zope. Now,

> > I need to do the same but with mySQL. How do I do this? I have a 
> > windows version of mysql installed on my local drive. I imagine that

> > I need to create a data source but I don't know which driver to set 
> > up the data source. Any Suggestions?
> >
> > Thank You,
> >  Laura
> --
> Charlie Clark
> eGenix.com
>
> Professional Python Services directly from the Source
>  >>> Python/Zope Consulting and Support ...
http://www.egenix.com/
>  >>> mxODBC.Zope.Database.Adapter ...
http://zope.egenix.com/
>  >>> mxODBC, mxDateTime, mxTextTools ...
http://python.egenix.com/
> ______________________________________________________________________
> __
>
> ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! 
> ::::
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org http://mail.zope.org/mailman/listinfo/zope-db
>



More information about the Zope-DB mailing list