Home » Infrastructure » Windows » Error with ODBC and oracleClient92 Release 9.2.0.3.0
Error with ODBC and oracleClient92 Release 9.2.0.3.0 [message #115093] Thu, 07 April 2005 07:53 Go to next message
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
Re: Error with ODBC and oracleClient92 Release 9.2.0.3.0 [message #124966 is a reply to message #115093] Wed, 22 June 2005 10:01 Go to previous messageGo to next message
McCoy1
Messages: 2
Registered: June 2005
Junior Member
Did you ever resolve this issue?
Re: Error with ODBC and oracleClient92 Release 9.2.0.3.0 [message #125002 is a reply to message #115093] Wed, 22 June 2005 12:41 Go to previous message
McCoy1
Messages: 2
Registered: June 2005
Junior Member
Actually I just resolved this myself. The client had Oracle 8i and needed Oracle 9i and the ODBC connections added for the database she was trying to hit. She also needed the updated tnsnames.ora file.
Previous Topic: Error Codes
Next Topic: ADO and 9i with C++
Goto Forum:
  


Current Time: Sun Dec 16 15:42:42 CST 2018