[egenix-users] Unix Plone to MSSQL

[Charlie Clark]

Am 27.02.2009, 01:12 Uhr, schrieb Jeff Fincher <jeff.fincher at verizonbusiness.com>:

> I am running Zope/Plone 3.2.1 on RHEL and want to connect to MS SQL on a
> another server. I purchased mxODBC to do this job. Now I am wondering,
> is mxODBC a DA that will let me do that or do I need additional
> components?
>It seems that mxODBC
> will talk to iODBC which in turn
> will talk to a driver like unixODBC or FreeTDS
> that will finally talk to the MS SQL server.

Hi Jeff,

that is indeed the standard procedure. We do, however, offer mxODBC Connect for just this kind of scenario. This involves installing a server component on the Windows machine and a client component on the Zope machine. The two components communicate in pure Python and handle all networking issues so we hope that this setup is not only easier to maintain but also faster and more reliable. There, is currently no Zope DA for this so you would have to handle connections yourself from Python code in Zope. There will soon be a buildout recipe that supports this configuration.

Charlie

-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try our new mxODBC.Connect Python Database Interface for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/