|
Posted by Andy Hassall on 10/29/06 22:13
On 29 Oct 2006 13:40:59 -0800, "dan_e" <the.route@gmail.com> 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@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Navigation:
[Reply to this message]
|