Error with ODBC and oracleClient92 Release 9.2.0.3.0

Tom Maier · *nix forums beginner Joined: 13 Apr 2005 Posts: 1

Hello!

We have an Excel-File with queries to our Oracle DB. To get the data
we use "ThisWorkbook.RefreshAll".

Problem:
With 'oracleClient92 Release 9.2.0.3.0 - Production' all worked as it
should. But with 'oracleClient92 Release 9.2.0.5.0 - Production' we
get an error.

Excel shows the Msg:

"Oracle ODBC Driver
Internal error - unable to initialize NLS during driver load."

So if checked the NLS-Settings:

Client:
Windows XP Prof. SP1

SQL*Plus: Release 9.2.0.5.0 - Production

\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\
NLS_LANG --> AMERICAN_AMERICA.WE8ISO8859P1

\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0
NLS_LANG --> AMERICAN_AMERICA.WE8ISO8859P1

\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
NLS_LANG --> AMERICAN_AMERICA.WE8ISO8859P1

Server:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production

NAME TYPE VALUE
------------------------------------ ----------- --------
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string

I can't see anything that is wrong here!?

Now I tested with 'Release 9.2.0.3.0 - Production':
(To get the Client to 9.2.0.3.0, I've just copied the 'bin' Folder
from the oracleClient92 Folder of another PC (no new installation).)

I've changed the NLS_LANG Reg-Keys to GERMAN_GERMANY.WE8ISO8859P1. All
worked fine.
Then I've changed the Keys to JAPANESE_JAPAN.JA16EUCTILDE. With this
setting in can't connect to the database.

So this means, my ODBC-Problem with Release 9.2.0.5.0 is after the
connection to the Database, right?

Does anyone know this error? Can your help me?

Thanks a lot!

Tom Maier

Google