Installation problems DCOracle2 & W2000

[Fazal Majid]

brueckd at tbye.com wrote:
> Aha! Here's what I think the problem is: the DCOracle2 bundle off the Zope 
> site comes all wrapped up in the Zope database adapter (ZOracleDA), so 
> your above script is actually trying to import the DA and not the 
> DCOracle2 package itself (I can see why this is confusing - both 
> directories are named DCOracle2 but one is a subdirectory of the other!).

I just reinstalled Oracle 9.2.0.1 + Python 2.2 + DCOracle2 on a new 
computer so I can reproduce the steps to a correct install. I think Dave 
is right on track here, there is a name conflict between the module 
DCOracle2.py, which is standalone without Zope and that you want to use, 
and DCOracle2 the Zope database adapter package directory which is used 
only from within Zope.

Here is my setup:

PYTHONPATH=D:\Etc\DCOracle2

D:\Etc\DCOracle2>python
Python 2.2.1 (#34, Apr  9 2002, 19:34:33) [MSC 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
 >>> import DCOracle2
 >>> d=DCOracle2.connect('scott/tiger at database')
 >>> d.execute('select SYSDATE from dual')
1
 >>> d.fetchall()
[[OracleDate("2002-06-26 17:31:57")]]
 >>> ^Z
D:\Etc\DCOracle2>dir
  Volume in drive D is MAJID
  Volume Serial Number is B8C2-4135

  Directory of D:\Etc\DCOracle2

2002-06-11  14:47       <DIR>          .
2002-06-11  14:47       <DIR>          ..
2002-06-05  15:00               73,728 dco2.pyd
2002-06-05  12:16               56,957 DCOracle2.py
2002-06-05  15:00              180,304 win32-python-1.5.2-805-dco2.pyd
2002-06-05  15:00               73,728 win32-python-1.5.2-dco2.pyd
2002-06-05  15:00              180,298 win32-python-2.1-805-dco2.pyd
2002-06-05  15:00               73,728 win32-python-2.1-dco2.pyd
2002-06-05  15:00               73,728 win32-python-2.2-dco2.pyd
2002-06-05  12:16                1,725 __init__.py
2002-06-26  17:21               46,293 DCOracle2.pyc
                9 File(s)        760,489 bytes
                2 Dir(s)   6,778,052,608 bytes free