| Error with ODBC and oracleClient92 Release 9.2.0.3.0 [message #115093] |
Thu, 07 April 2005 07:53  |
tom3025
Messages: 1
Registered: April 2005
|
Junior Member |
|
|
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: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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
