Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Date time value error in Ms Access using pass through queries

From: c k <shreeseva(dot)learning(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [GENERAL] Date time value error in Ms Access using pass through queries
Date: 2011-09-23 11:42:43
Message-ID: CAN2Y=uMYRe=cc0voGzWsYgOQu4u1AtmFZHYYxPt4KhJMOkPZjQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
I found the solution. Earlier for 9.0 database I have changed a line as
Datestyle= ' ISO, mdy' to DateStyle= "ISO, dmy'. So it was working fine. For
9.1 I forgot to make this change in postgresql.conf. After making the change
everything is working fine.

Regards,
C P Kulkarni

On Fri, Sep 23, 2011 at 3:43 PM, c k <shreeseva(dot)learning(at)gmail(dot)com> wrote:

> As I have connected to postgres from MS Access, it thrown the error.
> Now I have updated ODBC driver, still same problems comes for 9.1 and not
> for 9.0. There should be some thing that has changed in 9.1 release which
> prevents from auto-conversion of format of date from client to server.
> From package I have installed postgres 9.1 using EnterpriseDB one click
> installer.
> ODBC driver has version 9.0.3.10
> Should I file a bug for this?
>
> Regards,
> C P Kulkarni
>
>
> On Thu, Sep 22, 2011 at 7:42 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:
>
>> On Thursday, September 22, 2011 2:25:40 am c k wrote:
>> > It shows error as 'Date/time value out of range' and gives the actual
>> part
>> > of the sql statement which contains date as the details.
>>
>> What program threw the error, Access,ODBC or Postgres?
>>
>> >
>> > I have installed both databases at different locations on same drive on
>> > Fedora 15 and accessing it from Windows Xp virtual machine.
>> > And both databases from 9.0. and 9.1 have same structure and and it is
>> > found that this problem comes for all date columns for 9.1. There is no
>> > such problem for 9.0 at all.
>>
>> Define install, from source or package?
>>
>> >
>> > When same query is executed from PgAdmin it executed successfully for
>> 9.1.
>> > So the error may be in ODBC driver and some things related to date data
>> > type may be changed in 9.1.
>>
>> What version of the ODBC driver are using?
>>
>> FYI, there is a Postgres ODBC list:
>> http://archives.postgresql.org/pgsql-odbc/
>>
>> >
>> > C P Kulkarni
>> >
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)gmail(dot)com
>>
>
>

In response to

pgsql-admin by date

Next:From: Виктор СтолбинDate: 2011-09-23 12:38:00
Subject: Fwd: Invalid version while creating PostgreSQL 9.1 cluster
Previous:From: c kDate: 2011-09-23 10:13:28
Subject: Re: [GENERAL] Date time value error in Ms Access using pass through queries

pgsql-general by date

Next:From: hamann.wDate: 2011-09-23 12:12:32
Subject: Re: looking for a faster way to do that
Previous:From: Thomas KellererDate: 2011-09-23 11:40:35
Subject: Re: Problem with pg_upgrade 9.0 -> 9.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group