[Zope] ZmxODBC vs ZODBC

[Andy McKay]

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 )
>