[DB-SIG] Python to SQL Server

[M.-A. Lemburg]

On 2008-06-10 11:49, Mark Matthews wrote:
> 
> On 10/06/2008, at 7:40 PM, M.-A. Lemburg wrote:
> 
>> On 2008-06-10 03:18, Mark Matthews wrote:
>>> Hello,
>>> I have a client that we have built a Python-PostgreSQL-Linux solution 
>>> for. It works well, very stable, robust ...
>>> However, they are a little keen on Microsoft products and are 
>>> enquiring about migrating to SQL Server (database only, leaving the 
>>> app running on Linux with Python)
>>> I am assuming the best way forward is mxODBC. Has anyone got any 
>>> better ideas on how to do this. Note that it must be very stable and 
>>> robust - this is the operations system in a finance company
>>
>> If you want to connect to SQL Server from a Linux box, the best way
>> to do this is to use a commercial ODBC driver such as the one from
>> EasySoft and then talk to it via mxODBC.
>>
>> You could also use the free FreeTDS ODBC driver, but it's not really
>> production quality and we don't recommend using it for mission
>> critical applications.
>>
>> BTW: We'll also announce a new product this week which works much
>> like a bridge and avoids having to find an ODBC driver for client
>> application platform. It's still in beta, but we expect the final
>> release by the end of the month.
> 
> 
> Hello
> 
> Thank you for the prompt response. I had been looking at EasySoft, but 
> was hoping that there were alternatives.

OpenLink and DataDirect also have SQL Server drivers, so you could
try those as well.

> I am *very* keen to test your product. Even thought I am not convinced 
> that the client will migrate a stable production system, they do have 
> other SQL Server databases that we extract data from (FreeTDS - which we 
> know to not be production quality).

We'll be announcing a public beta this week and also post a copy
to this list.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 11 2008)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2008-07-07: EuroPython 2008, Vilnius, Lithuania            25 days to go

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX 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