[ale] Accessing MS SQL Server from Python on Linux

James P. Kinney III jkinney at localnetsolutions.com
Thu Oct 27 18:04:13 EDT 2005


On Thu, 2005-10-27 at 17:38 +0000, Jeff Hubbs wrote:
> I'm having trouble wrapping my head around the subject problem.  I'm 
> used to importing the pygresql module into python and then I can have 
> Python like:
> 
>     db = _pg.connect(db_name, db_location)
> 
> and so forth.
> 
> Anyway, I'm finding myself needing to pull the same trick on a MS SQL 
> Server instance on another machine and I'm not finding anything as 
> straightforward.
> 
> On Freenode IRC, I'm being directed to things like the Sybase module for 
> Python (for which there seems to be no Gentoo ebuild, leading me to 
> believe that this isn't widely used) and FreeTDS, but I'm not seeing at 
> all how these things integrate.
> 
> What would be typical practice for doing what I'm trying to do?

other than fdisk, emerge linux_stuff?

I have not seen any python tools for accessing MSSQL. It might be
possible using ODBC as MSSQL supports it and there is a pyodbc
connector.

Ah HA!
http://pymssql.sourceforge.net/
> 
> Jeff
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part




More information about the Ale mailing list