ORA-01882: timezone region not found in Entity Framework

Question

Getting this error on trying to update an Oracle Connection suing Entity Framework from a ASP.Net MVC Web Application.

score 0 · Answer 1 · answered Feb 23 '16 at 18:23

0

SQL Server Developer: Edit this config file: C:\Program Files\sqldeveloper 3\sqldeveloper\bin\sqldeveloper.conf then add this line anywhere in the file:

    AddVMOption -Duser.timezone="+02:00" (My time zone)

Oracle Data Modeler Edit this config file: C:\Program Files\datamodeler 3\datamodeler\bin\datamodeler.conf, then add this line anywhere in the file:

    AddVMOption -Duser.timezone="+02:00" (My time zone)

source here

answered Feb 23 '16 at 18:23

profesor79

9,213
3
31
52

4

I am trying to do Entity Framework database-first from Visual Studio and not connecting from SQL Developer – kolexinfos Feb 23 '16 at 18:58
are you using ODP.NET to connect to oracle server? If not could you specify how the program connects to DB? – profesor79 Feb 23 '16 at 22:00
I am using ODP.Net driver in Visual Studio Wizard for creating an Entity Framework Model from Database – kolexinfos Feb 24 '16 at 09:07

score 0 · Answer 2 · answered Feb 23 '16 at 18:25

0

According to this link, you need to edit the config file that was installed. it will either be C:\Program Files\sqldeveloper 3\sqldeveloper\bin\sqldeveloper.conf or C:\Program Files\datamodeler 3\datamodeler\bin\datamodeler.conf

And add the following line:

    AddVMOption -Duser.timezone="+02:00"

Modified for your timezone, of course.

answered Feb 23 '16 at 18:25

William Karnesky

86
7

4

I am trying to do Entity Framework database-first from Visual Studio and not connecting from SQL Developer – kolexinfos Feb 23 '16 at 18:58

ORA-01882: timezone region not found in Entity Framework

2 Answers2

Linked