DBD-Oracle - Compiled OK on cygwin, but getting UNKNOWN OCI Status 1804

Posted on Mon Nov 21 21:58:05 2005 by aprilmb
Compiled OK on cygwin, but getting UNKNOWN OCI Status 1804

Hi there,

I am trying to do a connection to a remote Oracle database from the following setup: cygwin on Windows, Perl 5.8.7, DBD-Oracle 1.16, Oracle client 9.

I've done all kinds of tests, using environmental variables (ORA_NLS33, ORACLE_HOME, TWO_TASK, tnsnames file), and also passing all the info (host, port, service name, username, and pass) to the DBI connect method explicitly. Every configuration I try, I get that OCIInitialization error. Any advice? I'm out of ideas.

I can connect fine via the Oracle client, independently of Perl and cygwin, so I don't think there's a problem with the overall Oracle DB/client setup.

Should I try Oracle Client 8?

Thanks, April
Direct Responses: 1372 | Write a response