[Zope] ZmxODBC vs ZODBC
Andy McKay
andym@ActiveState.com
Mon, 23 Apr 2001 08:22:33 -0700
When connecting to sql server i found the order in a simple select query
mattered. For example "select a, b from c" worked, "select b, a from c" did
not. As one of my colleagues said "I didnt believe you until I tried it
myself".
Cheers.
--
Andy McKay.
----- Original Message -----
From: "alan runyan" <runyaga@thisbox.com>
To: <zope@zope.org>
Sent: Monday, April 23, 2001 12:33 AM
Subject: [Zope] ZmxODBC vs ZODBC
> ok. just got ZmxODBC working:
>
> * install ZmxODBC and ZODBC
> * copy the sql.pyd file from the ZODBC directory to the ZmxODBC directory
> * copy mx /lib/python/Shared to /lib/python ;) to get it in the PYTHONPATH
> * uncomment #from sql import * that is in ZmxODBC/dbi.py (could be dba.py,
I
> forgot) and all works well.
> * crank zope up and hopefully you get no errors ;)
>
> now, I havent look too heavily into this, but it seems that ZmxODBC seems
to
> work just fine. I heard some people saying it was unpredicatable. could
> someone please point me to instability problems you may have found with
> ZmxODBC? I am looking for the most reliable way to access ODBC
datasources
> from ZOPE. I have used mxODBC (outside of ZOPE) before and its worked
quite
> well. I'm doing a unrealistic test w/ httpperf and I'm not having
problems
> and memory usage isnt blowing up. I dont see any problems. mind you, I'm
> only using it against MS Access - SQLServer will be tomorrow.
>
> please email me if you have reproducible problems w/ ODBC and ZOPE. I
have
> a client that is interested in ZOPE on Windows -- so far it looks like it
> works reasonably well w/ ZmxODBC and Access (they will be using Access and
> SQLServer).
>
> thanks,
> runyaga
>
>
> _______________________________________________
> Zope maillist - Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
>