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