[DB-SIG] DCOracle help

[Matthew Cahn]

Hugh, I'd like to echo what Andy Todd said -- install DCOracle2:

   http://www.zope.org/Members/matt/dco2/

This document has some nice examples toward the end:

   http://www.zope.org/Members/matt/dco2/dco2doc

I'm using the "latest" CVS version (well it was the latest a month ago).

Regards,
Matthew Cahn

Andy Todd wrote:

> Hugh,
>
> Welcome to the wonderful world of databases and Python.
>
> Hugh Frater wrote:
>
> > I'm a 1st year computer science student at Cardiff university, and
> > have decided to use python to implement my first year project (WWW
> > based library system). I have also decided to use the uni's oracle
> > box to to the database stuff on. I've got the sys admin to install
> > DCOracle, but am having real trouble with the following:
> >
> > I can't find any DCOracle documentation out there!
>
> http://www.zope.org/Products/DCOracle
>
> Should be your starting point. If its not there, it doesn't exist.
>
> >
> > And,
> >
> > If I try and create a cursor from my connection object, I get a
> > message which says that cursor is not supported on my Connection
> > object. Does anyone know what I'm doing wrong. I presume that my
> > import oci_ line is OK?
> >
> > Any help would be great,
> > Hugh Frater
> >
>
> Ah, now your other problem is that DCOracle is an old interface module
> and is largely deprecated these days - apart from folks who have it
> running like a dream of course ;-)
>
> The major drawback of DCOracle is that its written using the Oracle 7
> OCI libraries and these are a definite no-no these days according to the
> lovely people at Redwood Shores. It will work with Oracle8i and above
> but you are into the realms of tin can and string solutions, so its best
> to use a more up to date interface module (like DCOracle2 or cx_Oracle).
>
> Its minor drawback is that it doesn't comply with the Python DB-API 2.0
> (http://www.python.org/topics/database/DatabaseAPI-2.0.html) and most of
> the people on this list are more conversant with that syntax and would
> be able to be more helpful if you were too.
>
> If all else fails, perhaps you could post your code and we can take a
> stab at debugging it anyway. For starters, we could tell you whether or
> not your import line is OK.
>
> Regards,
> Andy
> --
> -----------------------------------------------------------------------
>  From the desk of Andrew J Todd esq.
> "So I curtailed my Walpoling activities, sallied forth and infiltrated
>   your place of purveyance to negotiate the vending of some cheesy
>   comestibles." - Monty Python.
>
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig