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