Re: [dabo-users] pymssql is it working?

Author: python@bdurham.com

Posted: 2012-01-10 at 12:00:25

Ed,

> Is there a dbapi-compliant ODBC class?

Yes. There are several.

I think pyodbc is the way to go (dbapi compliant, MIT license, cross

platform, Python 2.x/3.2, etc)

http://code.google.com/p/pyodbc

http://code.google.com/p/pyodbc/wiki/GettingStarted

<snipped>

pyodbc is a Python 2.x and 3.x module that allows you to use ODBC to

connect to almost any database from Windows, Linux, OS/X, and more.

It implements the Python Database API Specification v2.0, but additional

features have been added to simplify database programming even more.

pyodbc is licensed using an MIT license, so it is free for commercial

and personal use. You can even use the source code in your own projects.

Installers for Windows are available here and most Linux distributions

are starting to provide pre-compiled packages. Full source code is also

available.

Version 3.0.2 is the first official pyodbc release that supports both

Python 2 and Python 3 (3.2+).

If you are on Linux and connecting to SQL Server, you may also be

interested in Microsoft's new Linux ODBC driver:

http://www.microsoft.com/download/en/details.aspx?id=28160 Check your

bitness - a Google search may be required ;)

If you are on Windows, there are prebuilt installers linked on the left.

Most Linux distributions include pyodbc in their packages, but you may

need to build your own to ensure you are using the latest

</snipped>

Malcolm

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/1326214825.3648.140661021663221@webmail.messagingengine.com

©2012 python@bdurham.com