SQL Server

[Guest]

Greetings, All-

About 2 months ago I was laid off and in the process of being walked to the door I lost most of my Python tips and tricks. Looks like I'm back on theair with a great job and am ready to start coding again. I'd like to know what I have to do to connect to a Microsoft SQL server database. I did it at my old job but forgot the process.

Thanks for your help. BTW, I'm the first full-time programmer in this particular shop and they are quite interested in using Python as their languageof choice! This could be a lot of fun.

Greg Lindstrom

[Steve Holden]

Re: SQL Server

yuba@cyberback. com wrote:
[color=blue]
> Greetings, All-
>
> About 2 months ago I was laid off and in the process of being walked to the door I lost most of my Python tips and tricks. Looks like I'm back on the air with a great job and am ready to start coding again. I'd like to know what I have to do to connect to a Microsoft SQL server database. I did it at my old job but forgot the process.
>
> Thanks for your help. BTW, I'm the first full-time programmer in this particular shop and they are quite interested in using Python as their language of choice! This could be a lot of fun.
>[/color]
Congratulations on seeing a wage packet again!

Easiest would be to use mxODBC (downloadable from www.egenix.com, but
don't forget to buy a license if you are using it commercially).

regards
Steve

[David Fraser]

Re: SQL Server

Steve Holden wrote:[color=blue]
> yuba@cyberback. com wrote:
>[color=green]
>> Greetings, All-
>>
>> About 2 months ago I was laid off and in the process of being walked
>> to the door I lost most of my Python tips and tricks. Looks like I'm
>> back on the air with a great job and am ready to start coding again.
>> I'd like to know what I have to do to connect to a Microsoft SQL
>> server database. I did it at my old job but forgot the process.
>>
>> Thanks for your help. BTW, I'm the first full-time programmer in this
>> particular shop and they are quite interested in using Python as their
>> language of choice! This could be a lot of fun.
>>[/color]
> Congratulations on seeing a wage packet again!
>
> Easiest would be to use mxODBC (downloadable from www.egenix.com, but
> don't forget to buy a license if you are using it commercially).
>
> regards
> Steve[/color]

I reckon its easier to use ADO. pyado.sourcefor ge.net or
jtoolkit.source forge.net have tools to do this but are GPL

David

[Jarek Zgoda]

Re: SQL Server

David Fraser <davidf@sjsoft. com> pisze:
[color=blue]
> I reckon its easier to use ADO. pyado.sourcefor ge.net or
> jtoolkit.source forge.net have tools to do this but are GPL[/color]

Adodbapi (http://adodbapi.sourceforge.net/, LGPL) offers the same
functionality.

--
Jarek Zgoda

http://jpa.berlios.de/