[Zope] Compiling ZOracleDA on remote machine (was Re: SQL que ries?)

[Dom Mitchell]

> -----Original Message-----
> From: Ethan Fremen [mailto:mindlace@majordomo.net]
> Sent: Tuesday, October 26, 1999 11:31 AM
> To: Dom Mitchell
> Cc: zope@zope.org
> Subject: Re: [Zope] Compiling ZOracleDA on remote machine (was Re: SQL
> queries?)
> 
> 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.

Your best bet would probably be to install a secondary Zope on
the HP box.  It's not an easy route, but it appears to be the
best of a bad choice.

-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
**********************************************************************