|
|
Posted by dan_e on 10/29/06 22:34
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@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]
|