Date time value error in Ms Access using pass through queries

From: c k <shreeseva(dot)learning(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Date time value error in Ms Access using pass through queries
Date: 2011-09-21 10:08:11
Message-ID: CAN2Y=uOTm0veKAiKeo3XCafRW9DdkjvjeMDbVdp_KOzERbAngw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hello,

I got a error yesterday while I have updated my development database to 9.1
from 9.0.4. I backed up my database from 9.0 and restored in 9.1. It well
successfully. When running a query which calls a function, having date value
as IN parameter, it gives me the error as date/time value out of range. But
when same query is executed using a database from 9.0.4 it runs successfully
without any error. Both databases have a variable 'DateStyle=DMY' set. All
connection parameters are same for both. What is the problem? Does some
thing is changed in 9.1 or I have to wait till new ODBC driver is released?
I am using four digit year format and regional settings are set to use
dd/mm/yyyy style on windows and MS access uses them. Please give your reply.

Thanks and regards,

C P Kulkarni

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Henrique Teófilo 2011-09-21 11:52:15 Errors recovering database
Previous Message Julius Tuskenis 2011-09-21 08:41:11 Re: currval()

Browse pgsql-general by date

  From Date Subject
Next Message c k 2011-09-21 10:17:54 Re: problem connecting postgresql 9.0 tables from vba
Previous Message Daniel Baktiar 2011-09-21 09:40:14 Re: Random multiple times