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
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() |
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 |