Tom Maier
04-13-2005, 02:57 AM
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
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