[Zope] ZOracle connection trouble

[Monty Taylor]

This is a multi-part message in MIME format.
--------------994973E32346635AB6D7B24D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

The user/passwd@SID is the correct format. Zope, however, probably has
no clue about your environment variables. I would recommend looking at
the start-up script for Zope and adding the environment variables in
there (ORACLE_HOME is quite important, for one.)

Monty

"Bak @ kedai" wrote:
> 
> hullo everybody,
> 
> i want to access data on oracle server that resides on a remote machine.  i've
> installed oracle 8i(client side only) for linux on a redhat6.2 and managed to
> compile ZOracleDA with no problems.  i can connect ok from sqlplus and the test
> script that comes with ZOracleDA can import and connect to the remote database
> server OK.  however,  i can't create a ZOracleDA connection.
> 
> what's the connection string?  i've tried user/passwd@myora_SID -
> this barfed out connection "Invalid connection string:
> emedia/emedia123@nstdb"
> 
> user/passwd crashed zope.
> 
> i think my environment is all set since i can connect from sqlplus and the
> ZOracleDA test script runs ok.
> 
> what more should look at?  pointers/docs accepted.
> 
> p/s - i'm a Oracle newbie and not the DBA for the server that i want to access.
> i d/l DCOracleDA, compiled it, ran the test script successfully and stopped at
> that since i'm not quite sure what to do next
> 
> thanks
> 
> --
> ------------------------------------------------------
> http://www.kedai.com.my/kk
> Am I Evil?
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
--------------994973E32346635AB6D7B24D
Content-Type: text/x-vcard; charset=us-ascii;
 name="mtaylor.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Monty Taylor
Content-Disposition: attachment;
 filename="mtaylor.vcf"

begin:vcard 
n:Taylor;Monty
tel;cell:+31 (0)6 200 17486
tel;fax:+31 (0)20 589 5566
tel;work:+31 (0)20 589 5517
x-mozilla-html:TRUE
url:http://www.goldridge.net
org:Information Innovation
adr:;;Amstelveenseweg 88-90;Amsterdam;;1075 XJ;The Netherlands
version:2.1
email;internet:mtaylor@goldridge.net
title:Information Artist
x-mozilla-cpt:;0
fn:Monty Taylor
end:vcard

--------------994973E32346635AB6D7B24D--