[Zope] Python in LINUX to MS SQL.

[Tim Edwards]

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 at seznam.cz]
Sent: Wednesday, 7 April 2004 10:29 PM
To: jerry at westrick.com; zope at 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 at 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 )