[Zope-DB] DCOralcle2 "Invalid connection string"

[Emily Stumpf]

Greetings,

I need to get DCOracle2 working in zope and its not. :(

Finally I was able to get sqlplus on the webserver to connect 
successfully to my DB (not on the local machine) when I figured out that 
it was looking for tnsnames.ora in a slightly different place then I had 
it..

Okay, so here's the problem in zope:

When I try to create a DCOracle2 connection with connection string in 
this format login/password at DB where DB is set in tnsnames.ora (located 
in $ORACLE_HOME/network/admin/tnsnames.ora and now also in 
/etc/tnsnames.ora :P), I get "Invalid connection string"

Ok, and I just now noticed that sqlplus works with that connection 
string when ORACLE_HOME is Not set, but when I set it, it says:

SP2-0642: SQL*Plus internal error state 2165, context <bignumber>:0:0
Unable to proceed

?? Ahh :( What a mess..

Some information about this system:
OS: Linux Redhat Enterprise Workstation 3 Update 2 (2.4.21-20.EL)

DCOracle2 version: Tried with 1.3beta, and trying now with 1.2 but same 
problems.

Oracle: Oracle10g-basic-instantclient+some additional header files from 
a full Oracle 10g install from a different machine. So ORACLE_HOME is 
located in: /usr/lib/oracle/10.1.0.2/client and it contains the 
following directories:
bin lib network rdbms

rdbms was the directory of header files and contains a dir called public 
with a bunch of .h files.

How I compiled dco2.so:
For awhile I had trouble with getting this to compile at all. I think 
the combination that caused it to compile was putting that rdbms dir in 
$ORACLE_HOME, in src/dco2.c changing all instances of "dword *" to 
"dvoid *" and running "python setup.py install".

Was trying to test it with test/test1.py which I modified to:
import dco2
db=dco2.connect("username","pw","DB")

and I always get:
OCIEnvCreate failed: src/dco2.c:1497Traceback (most recent call last):
   File "test1.py", line 3, in ?
     db = dco2.connect("username","pw","DB")
dco2.DatabaseError: (67, '\xe0\xebV\xb7\xe0\xebV\xb7')

Interesting is if I run zope from /usr/local/zope/instance/bin/runzope I 
get

OCIEncCreate failed: src/dco2.c 1497

If anyone has any ideas, or if I should have given some information that 
I didn't please let me know asap.

Thanks!
-- Emily