Error with ODBC and oracleClient92 Release 9.2.0.3.0

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 Received on Wed Apr 13 2005 - 12:57:45 CEST