Re: Please Help! - PHP 5 + APACHE 2.2 + ORACLE 10.2 on windows box

Wow thanks for your quick reply. Here are the results:

PATH not set
NLS_LANG not set
NLS_NCHAR not set
ORACLE_HOME not set

Strange because i set Path and ORACLE_HOME in the system env vars....i
wonder why it's not picking these up? As far as the NLS vars are
concerned i don't really understand these?

Thanks again,
Dan.

Andy Hassall wrote:
On 29 Oct 2006 13:40:59 -0800, "dan_e" <the.route@xxxxxxxxx> wrote:

The error message i get is:

CONNECT error: ORA-12705: Cannot access NLS data files or invalid
environment specified

My system environment vars are set to the instantclient_10_2 dir, and
my tnsnames.ora file is set-up correctly....what could this mean?

One cause is an invalid value for NLS_LANG (as implied by the error message).

A typical value would be ".WE8ISO8859P1".

Run the following:

<?php
foreach (array('PATH', 'NLS_LANG', 'NLS_NCHAR', 'ORACLE_HOME') as $env)
{
print $env;

if (isset($_ENV[$env]))
{
print '=' . htmlspecialchars($_ENV[$env]);
}
else
{
print ' not set';
}

print '<br>';
}
?>

... and post the results.

(You might have to tweak 'PATH' into 'Path' or similar in case you have a
mixed-case PATH environment variable - this isn't wrong as such, since Windows
doesn't care what case it is).

--
Andy Hassall :: andy@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

.

Relevant Pages