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: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 **********************************************************************
At 12:29 26/10/99 , Dom Mitchell wrote:
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
I have, ready for packaging as soon as I have some time, two complimentary products that will help here. They are called Z Network Enabler and Z Network Client and are based on original code from Digital Creations. The Enabler will enable Searchable objects (like Z SQL Methods and ZCatalogs) available to other Zope servers using the Z Network Client. Z Client acts, dances and sings just like a local Z SQL Method, only its data comes from a remote machine. The Z Network protocol signs en compresses the data for reliability and speed, and the Z Network Client can cache the results just like a Z SQL Method does. Look out for an official announcement Real Soon Now (tm). -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-7502100 Fax: +31-35-7502111 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------
participants (2)
-
Dom Mitchell -
Martijn Pieters