all groups > sql server connect > march 2007 >
You're in the

sql server connect

group:

i need to connect python to sql2005


i need to connect python to sql2005 keyser soze
3/23/2007 6:04:59 PM
sql server connect:
hi
i need to connect
a small program written in Python
to a SqlServer 2005 database

how con i do it ?
can anyone link me to a resource ?

thanks

Re: i need to connect python to sql2005 Andrew J. Kelly
3/23/2007 7:42:12 PM
You should be able to connect with ODBC jsut like any other language. I
would start by looking at the Python web site:

http://www.python.org/

but a simple google search for python odbc gives a lot of hits. It's amazing
what a few keystrokes can buy you these days.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Re: i need to connect python to sql2005 keyser soze
3/26/2007 12:00:00 AM
of course, Andrew
i googled that...
( does exist anybody
that don't find answers on internet first ?! :-)

i promisse i did it,
what i found is an old adodbapi
developed near 2003, that is
before sql2005 being released


i wonder if there is other ways

thanks & regards!


"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> escribió en el mensaje
news:OrwyjTabHHA.4544@TK2MSFTNGP03.phx.gbl...
[quoted text, click to view]

Re: i need to connect python to sql2005 Andrew J. Kelly
3/26/2007 2:11:48 PM
If you google for "python odbc sql 2005" the very first hit is a 3rd party
that has 2005 drivers. There are several other links that appear useful as
well. Hopefully one of those will do the trick.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Re: i need to connect python to sql2005 keyser soze
3/26/2007 3:50:43 PM
well, i'm looking for something """free"""
but you are right,
i'll search in depth

thanks

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> escribió en el mensaje
news:%23G2y$I9bHHA.2316@TK2MSFTNGP04.phx.gbl...
[quoted text, click to view]

Re: i need to connect python to sql2005 Andrew J. Kelly
3/26/2007 4:01:55 PM
OK well that may narrow the search down a bit:).


--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Re: i need to connect python to sql2005 Sue Hoegemeier
3/26/2007 5:45:55 PM
I just googled it and found a free one on the first hit - a
download from sourceforge:
About pymssql
This module provides access to Microsoft SQL Servers from
Python scripts. It's the most efficient method of accessing
MS SQL Server's data from Python scripts.
http://pymssql.sourceforge.net/

And in the first few hits there was this:
Microsoft SQL Server Express / Python HOWTO
http://www.time-travellers.org/shane/howtos/MS-SQL-Express-Python-HOWTO.html

-Sue

On Mon, 26 Mar 2007 15:50:43 -0300, "keyser soze"
[quoted text, click to view]
Re: i need to connect python to sql2005 keyser soze
3/27/2007 12:00:00 AM
come on, hit me...

anyway, thanks both
for reply with respect
you are very kind

|<aiser Soze

"Sue Hoegemeier" <Sue_H@nomail.please> escribió en el mensaje
news:jfmg03toi97nkhslost93k5ir0s5ina8jc@4ax.com...
[quoted text, click to view]

AddThis Social Bookmark Button