[Tutor] Simple SQL server access...

[Kent Johnson]

Chris Hengge wrote:
> I've been doing some searching for ways to access existing SQL server 
> databases, but I'm finding so many different ways to do it, is there one 
> that anyone recommends for a "new to python" programmer? I've used VB 
> and C# for accessing SQL, so maybe something that would feel similiar to 
> that to get me started?

Take a look at http://adodbapi.sourceforge.net/ or 
http://pymssql.sourceforge.net/, they both support MS SQL Server using 
the standard DB-API interface.

adodbapi is Windows-only and LGPL licensed. pymssql runs on Windows and 
*nix, it is GPL licensed.

Documentation for DB-API is here:
http://www.python.org/dev/peps/pep-0249/

Kent