[DB-SIG] Oracle interface for Windows/NT

Victoria White white@fnal.gov
Sat, 17 Jan 1998 15:19:19 -0600

This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

        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

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

Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Victoria White
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Victoria White
n:              White;Victoria
org:            Fermi National Accelerator Lab
email;internet: white@fnal.gov
title:          Associate Head, Computing Division
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


DB-SIG  - SIG on Tabular Databases in Python

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