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

On Tuesday, January 10, 2012 12:00:25 PM python@bdurham.com wrote:

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

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

> 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

Yep! that's what I used recently. I just hard coded the connection string (in

the dbODBC.py) and it worked very well with Dabo. Of course I did not test

everything but I was able to read without issue. I am concerned about

writting because I haven't done any real testing. And of course only tested

on windows.

Johnf

_______________________________________________

Post Messages to: Dabo-users@leafe.com