DSN ERROR: ORA 1857 : not a valid time zone while connecting to oracle

[sankohar]

hi,
while making an ODBC DSN with oracle i am getting this error:
[oracle][odbc][ora] ORA-1857 : not a valid time zone

[Tequilaman]

Did you have the daylight saving time shift (back) last weekend in your area?

If application server and database server have different time settings this can happen. (also applies for virtual servers on one machine, if virtually separated in a test environment)

[sankohar]

Hi,
Thanks for reply. Here are the answers for your questions:
Yes we have the daylight saving time shift last weekend in our area.

Application server and database server have same time settings.

Did you have the daylight saving time shift (back) last weekend in your area?

If application server and database server have different time settings this can happen. (also applies for virtual servers on one machine, if virtually separated in a test environment)

[Killer42]

hi,
while making an ODBC DSN with oracle i am getting this error:
[oracle][odbc][ora] ORA-1857 : not a valid time zone

I suspect the VB forum isn't the best place to get help with this. You might also try asking in, say, the Oracle forum.

[Tequilaman]

Maybe you need to update the Oracle database through the admin tool to take over system time settings, if this was separated before.

I strongly assume the problem is on the Oracle side. These databases tend to be difficult after time shifts. I had to stop and restart a database last year when we had the time shift.

Maybe you can use TORA or TOAD to check if the database time if different to the system time and adjust it. - Tends to be easier while working on a connection, since you can view more things in one window

[QVeen72]

Hi,

You can Change the Database's Timezone using this :

ALTER database SET TIME_ZONE = 'US/Arizona';
Change this US/Arizona according to your Regional Settings..

But before doing this, Check the TimeZone using :

select DBTIMEZONE from dual;


Regards
Veena