ora-01882

ora-01882

Postby flutos » Mon 20 Dec 2010 20:10

I just got the licenced version of devart oracle driver and Im now getting this error trying to connect to the database:
ORA-01882: timezone region not found.

this is the connect string Im using:
User Id=system;Password=mypass;Direct=true;Server=oracle-win7;Service Name=dev7;Unicode=True;Pooling=True;

is there something different going on that Im missing?
flutos
 
Posts: 31
Joined: Tue 06 Oct 2009 21:55

Postby flutos » Mon 20 Dec 2010 20:14

forgot to mention my version is 6.0.69.0 for devart.data.oracle.dll but devart.dll.dll is 5.0.170.0
flutos
 
Posts: 31
Joined: Tue 06 Oct 2009 21:55

Postby StanislavK » Tue 21 Dec 2010 12:50

We were able to reproduce this problem with the Mobile edition only.

Could you please specify the version and NLS settings of the Oracle server you are connecting to?
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby flutos » Tue 21 Dec 2010 18:20

its oracle enterprise server 11.2.0.1
this is the nls settings:
nls_calendar TRUE
nls_comp BINARY TRUE
nls_currency TRUE
nls_date_format TRUE
nls_date_language TRUE
nls_dual_currency TRUE
nls_iso_currency TRUE
nls_language AMERICAN TRUE
nls_length_semantics BYTE TRUE
nls_nchar_conv_excp FALSE TRUE
nls_numeric_characters TRUE
nls_sort TRUE
nls_territory AMERICA TRUE
nls_time_format TRUE
nls_time_tz_format TRUE
nls_timestamp_format TRUE
nls_timestamp_tz_format TRUE


note that the 5.170 driver didnt have this problem, just the version 6 drivers.
flutos
 
Posts: 31
Joined: Tue 06 Oct 2009 21:55

Postby flutos » Tue 21 Dec 2010 18:23

given that is working in the version 5 and the licenced version 6 isnt, is there a way I can get the licenced version of version 5 until this is fixed in version 6?
flutos
 
Posts: 31
Joined: Tue 06 Oct 2009 21:55

Postby StanislavK » Wed 22 Dec 2010 09:22

In our environment, we couldn't reproduce the problem (with the Professional and Standard editions).

Could you please specify the edition you are using? As for the NLS parameters, please specify the results of the following query:
Code: Select all
select parameter, value from nls_database_parameters

Concerning prior versions, you should be able to download any of them from Registered Users' Area.

To do so, please proceed to the page with the dotConnect for Oracle download, and then to the link provided in the 'Previous Versions' section.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby flutos » Wed 22 Dec 2010 13:54

this is the nls settings, not one specific thing is we are using the unicode character set if that makes any difference:

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.2.0.1.0
flutos
 
Posts: 31
Joined: Tue 06 Oct 2009 21:55

Postby flutos » Wed 22 Dec 2010 14:02

when I went to the registered users area I only see the version 6 as downloadable , the username I was given is dcoracle600pro
flutos
 
Posts: 31
Joined: Tue 06 Oct 2009 21:55

Postby flutos » Wed 22 Dec 2010 14:07

here are all my database parameters if this helps too:
DICT.BASE 2 dictionary base tables version #
DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace
DEFAULT_EDITION ORA$BASE Name of the database default edition
Flashback Timestamp TimeZone GMT Flashback timestamp created in GMT
TDE_MASTER_KEY_ID
DBTIMEZONE -07:00 DB time zone
DST_UPGRADE_STATE NONE State of Day Light Saving Time Upgrade
DST_PRIMARY_TT_VERSION 11 Version of primary timezone data file
DST_SECONDARY_TT_VERSION 0 Version of secondary timezone data file
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
NLS_LANGUAGE AMERICAN Language
NLS_TERRITORY AMERICA Territory
NLS_CURRENCY $ Local currency
NLS_ISO_CURRENCY AMERICA ISO currency
NLS_NUMERIC_CHARACTERS ., Numeric characters
NLS_CHARACTERSET AL32UTF8 Character set
NLS_CALENDAR GREGORIAN Calendar system
NLS_DATE_FORMAT DD-MON-RR Date format
NLS_DATE_LANGUAGE AMERICAN Date language
NLS_SORT BINARY Linguistic definition
NLS_TIME_FORMAT HH.MI.SSXFF AM Time format
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format
NLS_DUAL_CURRENCY $ Dual currency symbol
NLS_COMP BINARY NLS comparison
NLS_LENGTH_SEMANTICS BYTE NLS length semantics
NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception
NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set
NLS_RDBMS_VERSION 11.2.0.1.0 RDBMS version for NLS parameters
GLOBAL_DB_NAME DEV7 Global database name
EXPORT_VIEWS_VERSION 8 Export views revision #
WORKLOAD_CAPTURE_MODE CAPTURE implies workload capture is in progress
WORKLOAD_REPLAY_MODE PREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress
flutos
 
Posts: 31
Joined: Tue 06 Oct 2009 21:55

Postby StanislavK » Wed 22 Dec 2010 15:17

We have reproduced and fixed the 'timezone region not found' problem. We will release the build with the fix in several days.

At the moment, the possible workaround is to set a positive timezone in the system time of your workstation.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby StanislavK » Thu 23 Dec 2010 10:44

We have released the new 6.0.70 build which includes the fix for this problem. The build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby flutos » Thu 23 Dec 2010 15:17

that fixed it.
flutos
 
Posts: 31
Joined: Tue 06 Oct 2009 21:55


Return to dotConnect for Oracle