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.