On Tuesday, January 10, 2012 12:00:25 PM [email protected] 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) > > 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
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: [email protected] 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/1816929.JWuJEu7ClZ@linux-12
