RE: [Zope] Compiling ZOracleDA on remote machine (was Re: SQL que ries?)
-----Original Message----- From: Ethan Fremen [mailto:mindlace@majordomo.net] Sent: Tuesday, October 26, 1999 11:17 AM To: phd@phd.russ.ru Cc: zope@zope.org Subject: [Zope] Compiling ZOracleDA on remote machine (was Re: SQL queries?)
Oleg Broytmann wrote:
You just need to connect your current DA to remote database.
thanks, Oleg and Phil, that's quite a relief. Now I'm confused about compiling the ZOracleDA. From what I read there, I need to have python installed on the Oracle machine and build the DA on that machine.
Sun= www server HPUX= Oracle server
Can I just copy $ORACLE_HOME/lib to the sun machine and then build the DA or is there some other voodo I'd have to bring along?
No, as they'd be different architectures. If you had a Sun Oracle installation, you could build it against that on the web server and still access it remotely (probably). -Dom -- ********************************************************************** This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. The email has been swept by MIMEsweeper for the presence of computer viruses. www.palmerharvey.co.uk **********************************************************************
Dom Mitchell wrote:
No, as they'd be different architectures. If you had a Sun Oracle installation, you could build it against that on the web server and still access it remotely (probably).
So if I wanted to go this route, I'd have to install Oracle on the web server, compile the DA (as static, I imagine?) remove Oracle, and then use it against the same version of Oracle on the HPUX box? yuck. Plus, this box is the live webserver, so I dunno how popular I'd be with this move... Can't I do something more simple and stupid... an ODBC connection or an external python method that passes SQL queries to the server? I'm not trying to do the all singing all dancing routine, just some queries. -- Ethan "mindlace" Fremen you cannot abdicate responsibility for your ideology.
participants (2)
-
Dom Mitchell -
Ethan Fremen