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

Re: Problem with the PGSQL-ODBC driver and MS Access

From: "P(dot)MO" <04mic4ht65k1nv3(at)jetable(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem with the PGSQL-ODBC driver and MS Access
Date: 2006-04-26 20:48:54
Message-ID: 6.2.3.4.2.20060426224148.02af4650@routeur (view raw or flat)
Thread:
Lists: pgsql-odbc
At 18:44 26/04/2006, you wrote:
>Hi,
>I have a user who has been converting some data from access to a 
>Postgresql 8.1.3 backend and we ran into
>a issue where some records would show up in Access with all the fields 
>as #deleted

I've seen this sometimes when using "timestamp": access doesn't
understand well the fractionnal part of it. You should instead use
timestamp(0). 

db=> create temp table zz ( field1   timestamp(0), field2 timestamp );
CREATE TABLE
db=> insert into zz values (now(),now());
INSERT 0 1
db=> select * from zz ;
        field1        |             field2
---------------------+----------------------------
 2006-04-26 22:44:42 | 2006-04-26 22:44:41.893001
(1 row)

----------------------------------------------------------
field1 will be understandable by access, not field2.
msaccess in that case will show "deleted" in all cells.

hopes that help .       P.



In response to

pgsql-odbc by date

Next:From: noreplyDate: 2006-04-27 03:44:47
Subject: [ psqlodbc-Bugs-1000620 ] SQLStatistics returns UNKNOWN instead of real column names
Previous:From: Ludek FinstrleDate: 2006-04-26 18:53:20
Subject: Re: Problem with the PGSQL-ODBC driver and MS Access

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