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 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.

Greg Lindstrom

 

[Steve Holden]

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.

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]

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

I reckon its easier to use ADO. pyado.sourceforge.net or
jtoolkit.sourceforge.net have tools to do this but are GPL

David

 

[Jarek Zgoda]

I reckon its easier to use ADO. pyado.sourceforge.net or
jtoolkit.sourceforge.net have tools to do this but are GPL

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