Page 1 of 1
ora-01882
Posted: Mon 20 Dec 2010 20:10
by flutos
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?
Posted: Mon 20 Dec 2010 20:14
by flutos
forgot to mention my version is 6.0.69.0 for devart.data.oracle.dll but devart.dll.dll is 5.0.170.0
Posted: Tue 21 Dec 2010 12:50
by StanislavK
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?
Posted: Tue 21 Dec 2010 18:20
by flutos
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.
Posted: Tue 21 Dec 2010 18:23
by flutos
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?
Posted: Wed 22 Dec 2010 09:22
by StanislavK
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.
Posted: Wed 22 Dec 2010 13:54
by flutos
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
Posted: Wed 22 Dec 2010 14:02
by flutos
when I went to the registered users area I only see the version 6 as downloadable , the username I was given is dcoracle600pro
Posted: Wed 22 Dec 2010 14:07
by flutos
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
Posted: Wed 22 Dec 2010 15:17
by StanislavK
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.
Posted: Thu 23 Dec 2010 10:44
by StanislavK
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/
Posted: Thu 23 Dec 2010 15:17
by flutos
that fixed it.