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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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