Re: Client Side NLS Settings, How do I do it

You are correct NLS_ parameters have to be set in the client side of all client server connections. To set the value on Win95 :

1. Run REGEDIT from a command prompt
2. Find the hive HKEY_LOCAL_MACHINE --> SOFTWARE --> ORCALE
3. Add a string NLS_DATE_FORMAT to this hive

Regards
David Russell

Biff Steel wrote in message <350a9788.156569384_at_news.alpha.net>...
>Hi,
>I have a unix database that we have changed the NLS_DATE_FORMAT in the
>initxxxx.ora. When we are on the unix box doing sqlplus, forms etc the
>NLS_DATE_FORMAT appears the way we would like but when I go in from an
>NT or Win95 machine, say in SQLPLUS the nls date format reverts to the
>DD-MON-YY standard/default. I have seen people mention that it also
>needs to be set on the client but I'd like to know what the best way
>to do this is.
>
>Thanks in advance for any replies.
>
>Keep your stick on the ice!
>John Moran jmoran_at_baraboo.com
Received on Sat Mar 14 1998 - 00:00:00 CST