Zope using ODBC on Linux question
Hi list, After searching everywhere I know of, I've found that my only options for getting Zope to talk ODBC on Linux are: 1) pay for egenix's Zope ODBC Database Adapter product 2) try your luck retrofitting ZODBCDA (last hacked for unixODBC in 2001, and doesn't seem to build on Zope 2.6.2 with python 2.2) This is a sort of tragedy for me, after getting unixODBC and freeTDS configured properly (I can talk to SQL Server from Linux!!!), and now I have to go buy a non-free product for Zope :( It's not giving up the free-as-in-free-beer part, as $95 means nothing to the overall budget of this project; but it's losing the free-as-in-free-speech aspect that bothers me. Is there a free project out there that I don't know about? -- mitchy
On Thu, 25 Sep 2003 17:07:01 -0400, Mitch Pirtle <mitchy@spacemonkeylabs.com> wrote:
Hi list,
After searching everywhere I know of, I've found that my only options for getting Zope to talk ODBC on Linux are:
Can sqlrelay help ? http://sqlrelay.sourceforge.net/ A quick glance at the faq suggests it'll do what you want.
Mitch Pirtle wrote at 2003-9-25 17:07 -0400:
... After searching everywhere I know of, I've found that my only options for getting Zope to talk ODBC on Linux are:
1) pay for egenix's Zope ODBC Database Adapter product 2) try your luck retrofitting ZODBCDA (last hacked for unixODBC in 2001, and doesn't seem to build on Zope 2.6.2 with python 2.2)
This is a sort of tragedy for me, after getting unixODBC and freeTDS configured properly (I can talk to SQL Server from Linux!!!), and now I have to go buy a non-free product for Zope :(
Only when you want to use ODBC... You can also use the "ZSybaseDA" over "freeTDS" to talk from Linux to an SQL server. Dieter
On Fri, 2003-09-26 at 13:49, Dieter Maurer wrote:
Mitch Pirtle wrote at 2003-9-25 17:07 -0400:
... This is a sort of tragedy for me, after getting unixODBC and freeTDS configured properly (I can talk to SQL Server from Linux!!!), and now I have to go buy a non-free product for Zope :(
Only when you want to use ODBC...
You can also use the "ZSybaseDA" over "freeTDS" to talk from Linux to an SQL server.
You smart, you can make it go... Now, where is this ZSybaseDA? Google, Zope and Freshmeat all come up empty... -- mitchy
Now, where is this ZSybaseDA? Google, Zope and Freshmeat all come up empty...
Not for me. Perhaps that prefixed 'Z' threw you. First page of a zope.org search for 'sybase' yields: http://zope.org/Products/DA/SybaseDA And this might be interesting to you too: http://zope.org/Members/TheJester/SybaseFreeTDS Don't know what exactly it patches... --jcc -- "My point and period will be throughly wrought, Or well or ill, as this day's battle's fought."
Mitch Pirtle wrote at 2003-9-26 15:11 -0400:
On Fri, 2003-09-26 at 13:49, Dieter Maurer wrote:
Mitch Pirtle wrote at 2003-9-25 17:07 -0400:
... This is a sort of tragedy for me, after getting unixODBC and freeTDS configured properly (I can talk to SQL Server from Linux!!!), and now I have to go buy a non-free product for Zope :(
Only when you want to use ODBC...
You can also use the "ZSybaseDA" over "freeTDS" to talk from Linux to an SQL server.
You smart, you can make it go...
Now, where is this ZSybaseDA? Google, Zope and Freshmeat all come up empty...
We dropped MS SQL Server in favour of PostgreSQL. Thus, I do no longer have the pieces available. And it is a long time ago that I accessed MS SQL Server via Sybase-Python over freeTDS. I believe to remember that I found the Python-Sybase adapter via a search on "comp.lang.python" (or its "db-sig") and that Zope.org has had an ancient DA for Sybase (anciency is not a problem, as nothing changed in this area). Dieter
Hi list, Well I got connectivity from Zope/Linux to MS SQL Server(TM) using: 1) unixODBC (www.unixodbc.org) 2) freeTDS (www.freetds.org) 3) SQL Relay (sqlrelay.sf.net) SQL Relay comes with a Zope adapter and Python as well. I'm still meeting some deadlines, but then will add instructions to my page at Zope.org. Thanks to David Orr, Alan James for pointing me at SQL Relay. AWESOME. -- mitchy
participants (4)
-
Alan James -
Dieter Maurer -
J. Cameron Cooper -
Mitch Pirtle