Forgot the link, didn't I? Sorry! http://sourceforge.net/projects/adodbapi Vernon
On Sat, Jul 31, 2010 at 6:15 PM, Ishe Chinyoka < chinyoka.consult...@gmail.com> wrote: > Thanks for this database tool, but where on earth can one download this? > > I had been looking for such a tool to connect my apps to databases. Thanks. > > Ishe > We all have the right to be wrong in our opinions but not in our facts. > > ----- Original Message ----- > *From:* Vernon Cole <vernondc...@gmail.com> > *To:* Discussion of IronPython <users@lists.ironpython.com> > *Sent:* Saturday, July 31, 2010 9:42 AM > *Subject:* [IronPython] Announcing adodbapi version 2.4.0 -- with COLUMN > NAMEdata access > > Announcing a new version of adodbapi... > > [ for those who may not know... > [ adodbapi is a pure Python package which fully implements the PEP-249 > db-api > [ using Microsoft ADO/db. > [ It runs on CPython versions 2.3 and later, IronPython 2.6 and later, > [ or Python 3.0 and later. > > I have often been frustrated by the need to count '?' marks for input > parameters > and remembering column numbers to get my SQL output. > This release fixes that by allowing the use of 'named' parameters as an > option, > and by returning 'SQLrow' objects which allow the use of column names. > > This version includes a distutils setup.py file, so installation is easy. > Just > 1) unzip > 2) "cd" to the directory you just unzipped. > 2) Execute the command: > python setup.py install > using the python distribution of your choice. > It even runs 2to3 automatically if you run it using a 3.n Python. > (Why didn't I do this years ago?) > > NOTE: on Vista (and 7?) you must run setup.py using the administrator > account to install on IronPython, > because setup.py does not elevate privileges for the source installer. > (Distutils can create a stand-alone binary installer which does elevate > privileges, but that feature is not yet supported by IronPython because it > has no zip library.) > > ALSO NOTE: I have _used_ this package with IronPython 2.7.A1, but not > _tested_ it, because 2.7's unittest package is broken. > > Here's what's new............................ > > * adodbapi version 2.4.0 -- in this version, > "fetchall()" and "fetchmany()" return an SQLrows object > ...which emulates a sequence of SQLrow objects. > "fetchone()" or the cursor's "next()" method return an SQLrow object. > An SQLrow object emulates a tuple of data fields. > An SQLrow object also appears to have an attribute for each column of > data. > therefore... > >>> import adodbapi > >>> myConnection = adodbapi.connection('someDSN') > >>> cur = myConnection.cursor() > >>> cur.execute("select name, rank, serialNumber from soldiers") > >>> row = cur.fetchone() > >>> assert row[0] == row['name'] > >>> assert row[1] == row.rank > >>> rows = cur.fecthall() > >>> assert rows[4,'serialNumber'] == rows[4][2] > > * adodbapi version 2.3.0 -- this is includes major refactoring and > specifically adds features for django support, including the ability for > the > programmer to change ado's SQL "paramstyle" at run time to select > between > 'qmark', 'format' and 'named' methods of passing SQL parameters. > ** also, in response to user requests, adodbapi will now use client-side > cursors by default. This will make rowcount and stored procedure return > > parameter values more readily available. > > > ------------------------------ > > _______________________________________________ > Users mailing list > Users@lists.ironpython.com > http://lists.ironpython.com/listinfo.cgi/users-ironpython.com > > > _______________________________________________ > Users mailing list > Users@lists.ironpython.com > http://lists.ironpython.com/listinfo.cgi/users-ironpython.com > >
_______________________________________________ Users mailing list Users@lists.ironpython.com http://lists.ironpython.com/listinfo.cgi/users-ironpython.com