We've tried using the combination of FreeTDS drivers, UnixODBC and egenix's mxODBC Zope DA that is mentioned in a previous post. It does work, however we have had problems with concurrency causing deadlocks and freezing the Zope process. This does not happen when running Zope on Windows 2000 and connecting to MSSQL. Give FreeTDS/UnixODBC/mxODBC a try and see how you go first - later on you can always swap in the ODBC-ODBC bridge or whatever instead of FreeTDS/UnixODBC. Let us know how it works. -----Original Message----- From: Jaroslav Lukesh [mailto:lukesh@seznam.cz] Sent: Wednesday, 7 April 2004 10:29 PM To: jerry@westrick.com; zope@zope.org Subject: Re: [Zope] Python in LINUX to MS SQL. Jerome R. Westrick wrote:
On Wed, 2004-04-07 at 00:55, Dennis Allison wrote:
Why not just connect to the MySQL Server directly? Check the MySQL manual on-line.
MS-SQL, not My-SQL
From Linux?
Did you browse all possible zope products at both www.zope.org and old.zope.org?
On Tue, 6 Apr 2004, Jason C. Leach wrote:
hi,
So I'm looking for a cost effective way to connect Zope on Linux to MS SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that is a bit expensive for what I need. Any other ideas? I really just need the basics from SQL (Select, Update, Join).
Look at: http://www.google.com/search?q=zope%20mssql%20OR%20%22ms%20sql%22&ie=UTF-8&o e=UTF-8&num=100 -- Jaroslav Lukeš -- Tento e-mail nemůže obsahovat VIRY jelikož nepocházi z virózního systému M$ Windows! _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )