Access to MS SQL from Linux?

[Joe Wong]

Hi Tim,

 Thanks for your quick reply. I happen to find another tool from
sourceforge:

http://pymssql.sourceforge.net/

It uses also FreeTDS. Just give it a try and it works ok for me this time.
:)

Regards,

- Joe

----- Original Message ----- 
From: "Tim Golden" <tim.golden at viacom-outdoor.co.uk>
To: <python-list at python.org>
Sent: Thursday, September 23, 2004 5:01 PM
Subject: RE: Access to MS SQL from Linux?


> [Joe Wong]
> |  Thanks for the pointer, I just tried freetds with sybase
> | python, I can use
> | tsql to connect to MS SQL but the python library failed
> |
> | Sybase.DatabaseError: Msg 2, Level 5701, Line 1851877443
> |
> | I am using MSSQL 2000 server, is this a problem?
>
> Unfortunately, I have no access to a Linux box at the mo,
> let alone the one I tested that setup on a while ago. However,
> just as reassurance, I connected with the Sybase and MSSQL
> modules to a 2000-database without any problems. It was by
> way of a proof-of-concept which never grew into anything else.
>
> I assume you followed all the build instructions (things
like -DHAVE_FREETDS
> and so on)? Probably worth checking just to make sure, although I've
> no idea what the effect would be if you hadn't.
>
> If you get nowhere by investigation, either try the ODBC route to
> see if that works for you and/or talk to the guys at Object Craft
> to see if they can help. (Don't know if they actively monitor this
> list or not).
>
> TJG
>
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________
> -- 
> http://mail.python.org/mailman/listinfo/python-list
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 2004/9/22