[DB-SIG] Python to SQL Server

[Mark Matthews]

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.

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).

--
Mark Matthews
http://www.object-craft.com.au