Connecting to Sql Server from Python

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

On Jan 24, 9:44 am, bg... at 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.


More information about the Python-list mailing list