Connecting to Sql Server from Python

Mike Driscoll kyosohma at gmail.com
Thu Jan 24 17:16:57 CET 2008


On Jan 24, 9:44 am, bg... at yahoo.com wrote:
> Hi,
>
> I have an sql server from which I'd like to read and write to. The
> connection string is as follows -
>
> "Data Source=localhost\SQLExpress;Initial Catalog=Test;Integrated
> Security=True;Pooling=False"
>
> Other properties as they appear in Visual Studio 2005 include -
>
> Data Provider: .NET Framework Data Provider for SQL Server
> State: Open
> Type: Microsoft SQL Server
>
> So my question is, how might I connect to my Test Catalog and update
> data within its tables via perl,
>
> Thanks,
>
> Barry.

If you want to do this in Perl, then why are you asking on a Python
list? In Python, there are many ways to accomplish this task. Take a
look at SQLAlchemy, SQLObject, pymssql or the adodb package.

http://pymssql.sourceforge.net/
www.sqlalchemy.org
http://www.sqlobject.org/
http://phplens.com/lens/adodb/adodb-py-docs.htm

Mike



More information about the Python-list mailing list