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
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
