i need to connect python to sql2005

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 ?
thanksYou 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
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:O93RJ1YbHHA.4656@.TK2MSFTNGP03.phx.gbl...
> 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
>|||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...
> 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
> "keyser soze" <bajopalabra@.hotmail.com> wrote in message
> news:O93RJ1YbHHA.4656@.TK2MSFTNGP03.phx.gbl...
>|||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
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:un3HEf6bHHA.260@.TK2MSFTNGP02.phx.gbl...
> 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...
> amazing
>|||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...
> 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
> "keyser soze" <bajopalabra@.hotmail.com> wrote in message
> news:un3HEf6bHHA.260@.TK2MSFTNGP02.phx.gbl...
>|||OK well that may narrow the search down a bit.
Andrew J. Kelly SQL MVP
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:Oz$N3X9bHHA.1216@.TK2MSFTNGP03.phx.gbl...
> 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...
>|||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/shan...thon-HOWTO.html
-Sue
On Mon, 26 Mar 2007 15:50:43 -0300, "keyser soze"
<bajopalabra@.hotmail.com> wrote:

>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...
>|||Lines: 102
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: line40.comsat.net.ar 200.47.78.40
Xref: leafnode.mcse.ms microsoft.public.sqlserver.connect:1884
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...
> 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/shan...thon-HOWTO.html
> -Sue
> On Mon, 26 Mar 2007 15:50:43 -0300, "keyser soze"
> <bajopalabra@.hotmail.com> wrote:
>
party[vbcol=seagreen]
as[vbcol=seagreen]
mensaje[vbcol=seagreen]
language. I[vbcol=seagreen]
>