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

Re: More Problems with ODBC and Access

From: Richard Huxton <dev(at)archonet(dot)com>
To: Steve Backman <earlysteve(at)earthlink(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: More Problems with ODBC and Access
Date: 2005-02-18 15:33:27
Message-ID: 42160AC7.8060304@archonet.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Steve Backman wrote:
> Related: What makes big int id's in pg show up as decimals in Access? 
> Could this be part of the problem? Does it matter whether the id's are 
> big ints or just ints? Do any of the settings refer to this? The 
> documentation of the settings leaves some room for improvement...

I'm not sure if Access supports 64-bit integers. If not, it could be 
that they're being mapped to floating-point (doubles presumably). That 
probably will cause difficulties if you're using bigints for ID numbers.

-- 
   Richard Huxton
   Archonet Ltd

In response to

pgsql-odbc by date

Next:From: laurie.burrowDate: 2005-02-18 16:53:11
Subject: Re: Cannot link to postgres 8.0.0 databases using ODBC from
Previous:From: Jeff EckermannDate: 2005-02-18 14:33:45
Subject: Re: Inserting dates instead of varchar?

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