On 2008-04-22 12:59:26 -0700, Dunston Rocks wrote:
> I had posted a few days ago about facing problems installing DBD::Oracle with 
> Oracle 10g client under Cygwin.

Regular client or instant client?

> Though those were circumvented successfully, when I try to run a simple 
> script that calls DBI->Connect, I get 
> 
> DBI connect(....) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, 
> NLS settings, permissions, etc. at tmp.pl line 12
> Error ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, 
> permissions, etc. at tmp.pl line 12.
> 
> ORACLE_HOME C:\oracle\product\10.2.0\client_2
> ORACLE_SID DEVDB
> TWO_TASK DEVDB
> NLS_LANG WE8ISO8859P15

This is not a valid NLS_LANG setting. It needs to be ".WE8ISO8859P15"
(or include a language and country, like
"american_america.WE8ISO8859P15").


I just ran into a similar problem with instant client 10.2.0.4 on Linux
(Debian Etch, instant client rpms converted to .deb with alien).

Wierdly enough it happened only during "make test". Running the tests
individually with "prove -b -v" worked, and at least my simple test
scripts work, too (Haven't tried anything complicated yet).

        hp

-- 
   _  | Peter J. Holzer    | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR       | I'd be programming in Java.
| |   | [EMAIL PROTECTED]      | I don't, and I'm not.
__/   | http://www.hjp.at/ |   -- Jesse Erlbaum on dbi-users

Attachment: pgpzdB2re9eCs.pgp
Description: PGP signature

Reply via email to