|
|
Posted by dan_e on 10/30/06 05:29
I found what was causing it. The registry didn't show the correct
ORACLE_HOME and the NLS_LANG key was set to NA. Renamed the key to
xLNS_LANG to fix this also.
It all works fine now....
Thanks for your help tho.
dan_e wrote:
> 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]
|