Zopistas, I'm kinda stressing on this one... Is there any way I can do SQL queries to a remote machine without having to have a DA and Zope instantiated on that machine? I just need to run queries, nothing more than that. (the machine is HP-UX and the database is Oracle 8.0.5.1) Thanks tremendously, -- Ethan "mindlace" Fremen you cannot abdicate responsibility for your ideology.
On Tue, 26 Oct 1999, Ethan Fremen wrote:
Is there any way I can do SQL queries to a remote machine without having to have a DA and Zope instantiated on that machine?
You just need to connect your current DA to remote database. Ask that database admin to grant you appropriate rights, and create new connection with connection string like this: database@host:port user passsword E.g.: baseball@sun.med.ru www (port and password omitted; not all fields required) Oleg. ---- Oleg Broytmann Foundation for Effective Policies phd@phd.russ.ru Programmers don't die, they just GOSUB without RETURN.
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? thanks, -- Ethan "mindlace" Fremen you cannot abdicate responsibility for your ideology.
Ethan, My feeling would be that you can do just that, I speak from experience of the MySQL DA of course so I may be wrong about the Oracle DA. I have compiled the MySQL DA on a machine without Zope and then move the library to the Zope Machine and it works fine. That assumes of course that the machines are the same, i.e. Both Linux or Both NT etc.. Good luck Phil phil@WigWamWeb.net -----Original Message----- From: mindlace@turtle.esosoft.net [mailto:mindlace@turtle.esosoft.net]On Behalf Of Ethan Fremen 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? thanks, -- Ethan "mindlace" Fremen you cannot abdicate responsibility for your ideology. _______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope (Related lists - please, no cross posts or HTML encoding! To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
Yeah should be simple, at least it is with mysql. When you create your database connection in Zope, fill in the properties of the creation form putting the remote server in as part of the connection string. For example I have a DB connection that looks to my db server so the connection string will look like (mysql): timetable@d031.ml.uwcm.ac.uk user password This means connect to the d031.ml.uwcm.ac.uk machine using the timetable db username is user and password is password. I hope that makes some sense. HTH Phil phil@wigwamweb.net -----Original Message----- From: mindlace@turtle.esosoft.net [mailto:mindlace@turtle.esosoft.net]On Behalf Of Ethan Fremen Sent: Tuesday, October 26, 1999 9:52 AM To: zope@zope.org Subject: [Zope] SQL queries? Zopistas, I'm kinda stressing on this one... Is there any way I can do SQL queries to a remote machine without having to have a DA and Zope instantiated on that machine? I just need to run queries, nothing more than that. (the machine is HP-UX and the database is Oracle 8.0.5.1) Thanks tremendously, -- Ethan "mindlace" Fremen you cannot abdicate responsibility for your ideology. _______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope (Related lists - please, no cross posts or HTML encoding! To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Ethan Fremen -
Oleg Broytmann -
Phil Harris