[Zope] - ZOracle DA...

[Jim Fulton]

David White wrote:
> 
> Hello,
> 
> I've been quietly following the development of Zope and I'm VERY
> impressed
> and happy to see such a wonderful tool available as open source.  I've
> been
> anxiously awaiting the release of DCOracle and the ZOracle database
> adapter
> and was overjoyed to see them arrive last week.  Unfortunately, I've run
> into a
> little snag which I was hoping someone could help me through.
> 
> I downloaded both DCOracle and the ZOracle DA (then realizing the
> ZOracle DA
> has DCOracle in the src directory...)  I extracted the ZOracle DA
> product to the
> <Zope_Home>/lib/python/Products location and I then compiled the
> DCOracle
> piece in the <Zope_Home>/lib/python.Products/ZOracleDA/src directory.  I
> ran
> the DCOracle_test.py file and got no errors.  Having thought all was
> well I moved
> the Buffer.so and oci_.so shared libs to the
> <Zope_Home>/lib/python/Products/DCOracle
> directory.  When I restarted Zope, the product appeared to be installed
> correctly
> as it wasn't 'broken' (no tracebacks), but when I tried to create a
> connection
> I got this traceback:
> 
> -------------------------------------------------------------
> 
> Invalid connection string: xxxxxx

Note that I Xed out the connection string.

Are you sure this was the correct connection string?

Does this connectiuon string work with sqlplus?

(snip)

> I have Zope being published through PCGI.  I have an apache webserver
> which is running as a user
> which 'knows' where ORACLE_HOME so the PCGI process should 'know' this
> too.  Did I just
> miss something obvioius?

If you think that the connection string is correct, you should
try setting ORACLE_HOME in the PCGI info file.

If you still have problems, try sending mail to
support@digicool.com.

Jim

--
Jim Fulton           mailto:jim@digicool.com
Technical Director   (888) 344-4332              Python Powered!
Digital Creations    http://www.digicool.com     http://www.python.org

Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email
address may not be added to any commercial mail list with out my
permission.  Violation of my privacy with advertising or SPAM will
result in a suit for a MINIMUM of $500 damages/incident, $1500 for
repeats.