Re: ODBC Problem

From: Tapan Trivedi <tapan.trivedi_at_abbnm.com>
Date: Thu, 07 Oct 1999 03:00:30 GMT
Message-ID: <6EC14873F507D3119B8C0090273C43490971B2@jdasoftware.com>

Brian,
Hi. I had posted this some time back on this newsgroup. I thought this might help you. Just check if you get the same error when you try the sqlplus session to the same instance also or not.

                                        Tapan

Hey Guys,
 I found a weird thing while updating the ODBC on several NT clients where in the ODBC upgrade takes off a few NLS LANG registry keys. Weird but true ! If you face a
'invalid NLS LANG parameter '
while connecting through SQL PLUS then just make sure that your registry has the following entries under HKLM/Software/Oracle

 NLSRTL32             "c:\orant\NLSRTL32"
 ORA_NLSRTL32         "c:\orant\NLSRTL32\DATA"

If you have Oracle8 client then substitute 33 for 32. This can be a minor hassle on a busy day so I thought I would let you guys know.

                                                                Tapan

Brian Peasland wrote:
>
> When I try to use an ODBC connection, I am getting the following msg:
>
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12705: invalid or unknown
> NLS parameter value specified.
>
> I checked the NLS environment variables (NT Registry) and they appear
to
> be fine. Any other suggestions?
>
> Thanks in advance,
> Brian Peasland
> peasland_at_edcmail.cr.usgs.gov

Received on Wed Oct 06 1999 - 22:00:30 CDT