[DB-SIG] Oracle interface for Windows/NT

[Bill Tutt]

I'd be more than willing to answer ANY questions you might have about the
PythonWin dbi, and odbc modules.

Bill

More computing sins are committed in the name of efficiency 
(without necessarily achieving it) than for any other single reason
---including blind stupidity.
> Python: the power of simplicity
> Perl:      the power of obscurity
> 
> 
> 
> -----Original Message-----
> From:	Victoria White [SMTP:white@fnal.gov]
> Sent:	Saturday, January 17, 1998 1:19 PM
> To:	jim@digicool.com
> Cc:	DB-SIG@python.org
> Subject:	Re: [DB-SIG] Oracle interface for Windows/NT
> 
> Jim,
>         Thank you for your reply.  I have still not heard from anyone who
> has
> actually got your oracledb module working under Windows/NT.
> At your suggestion I tried the dbi and odbc modules in Pythonwin.  The
> documentation of these is obscure, but eventually I came upon it.
> However,
> the description of the bugs and limitations and the lack of anyone
> using/supporting it was not a happy discovery.  I am certainly able to
> connect to the oracle database and do some simple things.  Have not yet
> figured out what to do about date/time and raw data types.   If I could
> locate others using either oracledb or the mxODBC module I would feel more
> comfortable using one of them - but looks like I have to build one or
> other
> of oracledb or mxODBC myself -  as an extension module.
> 
> In reference to this you talk about an NT-specific make file?   Are you
> assuming I will have to import the gnu tools and compiler to my NT system
> and
> not use the Microsoft Visual C++ environment, for example?  As I said in
> my
> first mail I really have no clue what I am doing on NT and don't
> particularly
> want to go deeply into it.  So once again - please someone - share your
> ready-built and ready-to-run Win32 oracledb  or mxODBC module with me if
> you
> have already done this.  Or at least your 10 step recipe.  Also let me
> know
> who else is using the built-in dbi and odbc in PythonWin.  Has anyone
> fixed
> any of the known bugs?
> 
>  Thanks a lot in advance
>                                     Vicky
> 
> Also - I think someone should remove the oramod stuff from the web pages
> and
> archive.  The only files that seem to be there are patches. These date
> from
> 1995 and the web page associated with the product says the author has
> abandoned it.  It is simply confusing to people to have out-of-date and
> usupported stuff offered in the Python archives.
> 
> Jim Fulton wrote:
> 
> > Vicky White wrote:
> > >
> > > I have been using the Digital creations database API module for oracle
> > > and have been following all the discussions on date/time. I am working
> > > with it on Sun/Solaris -but intend to also use it on SGI and Linux,
> > > which should not be a problem.  I just assumed that it would be easy
> to
> > > get it (or something else) with the standard DB API working under
> > > NT/windows.  However, now that I start looking closely I find nothing
> > > specifically for windows.
> >
> > We use a number of extension modules in our products.  None of them
> > have windows-specific code (other than the delay of setting a new type's
> > type to PyType_Type until the init function).
> >
> > Uh, I just noticed that this hasn't been done yet for the
> > oracle module. :-(  Here's what has to be done:
> >
> >   1. Change every line that looks like:
> >
> >        PyObject_HEAD_INIT (&PyType_Type)
> >
> >      and change it to look like:
> >
> >        PyObject_HEAD_INIT (NULL)
> >
> >   2. And then, for each type defined in the module, add a line like the
> >      following in the module init function:
> >
> >        Cursor_Type.ob_type=&PyType_Type;
> >
> > That's the only C change that *should* be necessary.  This does
> > no harm on Unix, so we write all new C modules this way.
> >
> > > Of the 3 things available
> > >    the Digital Creations API
> > >    the Lemburg mxODBC module
> > >    and Oramod (which I can find nothing for - only patches?)
> >
> > Have you tried the ODBC binary that comes with PythonWin?
> >
> > > nothing seems to be designed for a windows environment.
> >
> > None of our modules are "designed" for windows. We use the same sources
> > on windows and Unix.
> >
> > Of course, you need a Windows-specific make file.  Do you know
> > how to make one of these?
> >
> > > Do I really
> > > have to take the c code and the Python documentation and figure it all
> > > out myself -(not being much of a windows person).
> >
> > Not all of it.
> >
> > > Someone out there
> > > please give me help and guidance and if you have built a DBI interface
> > > to Oracle on windows please share your knowledge and experiences.
> >
> > If someone has successfully built the oracle module on
> > windows and is willing to share their binary, I'd be happy to
> > include it on out website.
> >
> > Jim
> >
> > --
> > Jim Fulton           mailto:jim@digicool.com
> > Technical Director   (540) 371-6909              Python Powered!
> > Digital Creattions   http://www.digicool.com     http://www.python.org
> 
>  << File: Card for Victoria White >> 

_______________
DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org
_______________