I have a Zserver running on one server and an Oracle DB on another server. Does anyone have experince with ZOPE connecting to an Oracle DB on a separate server? If so, what do I need to connect ZOPE to Oracle? Eric Dunn
eric.n.dunn@bankofamerica.com wrote:
I have a Zserver running on one server and an Oracle DB on another server. Does anyone have experince with ZOPE connecting to an Oracle DB on a separate server? If so, what do I need to connect ZOPE to Oracle?
Eric Dunn
The 'best' way to do this is to make sure you also install the Oracle client libraries on your Zope server box. Without this, you need to use some kind of SQL relay agent. I think you are better off with the Oracle client libraries. The client libraries may be installed from the Oracle installation CDs. Once you get it installed, you can use the Net 8 administrator to configure the tnsnames.ora file to identify your remote databases. -- Matt Kromer Zope Corporation http://www.zope.com/
Eric, You need to install the Oracle client libs on your Zope machine..and set up Oracle networking with a valid tnsnames.ora file, etc. pointing to the listener on the server machine.. (to do this, do the basic client install, then let it run the easy network configuration utility afterwards and answer the questions) Make sure that the proper ORACLE_HOME and TNS_ADMIN variables are set in your Zope environment, compile DCOracle 2 and ZOracleDA and you will be cooking. There is a HowTo on this process on the zope.org site. -Chris eric.n.dunn@bankofamerica.com wrote:
I have a Zserver running on one server and an Oracle DB on another server. Does anyone have experince with ZOPE connecting to an Oracle DB on a separate server? If so, what do I need to connect ZOPE to Oracle?
Eric Dunn
participants (3)
-
Chris Beaumont -
eric.n.dunn@bankofamerica.com -
Matthew T. Kromer