Re: int8 defined as text in MS Access?

Dave Page wrote:
>
> > -----Original Message-----
> > From: Patrick Hatcher [mailto:PHatcher(at)macys(dot)com]
> > Sent: 16 May 2002 23:22
> > To: pgsql-odbc(at)postgresql(dot)org
> > Subject: [ODBC] int8 defined as text in MS Access?
> >
> >
> > ODBC ver 7.1.10 and 7.2.0
> > Is it correct for an int8 value to be considered as a text
> > field when I link a table in Access? If so, just out of
> > curiosity, why is this so? TIA
>
> Yes, this has been the subject of discussion a number of times in the
> past. MS ADO (and other technologies) crash or get upset if the driver
> returns SQL_BIGINT for an int8 from the ODBC 2.5 driver, because it
> expects SQL_VARCHAR. With the (beta) ODBC 3.0 driver, you get an
> SQL_BIGINT which should work fine.

Unfortunately int8 -> SQL_BIGINT doesn't work well
even with ODBC 3.0 driver using MS Access. However
int8 -> SQL_NUMERIC seems to work with both 2.5 and
3.0 driver. Try the snapshot dll at
http://w2422.nsk.ne.jp/~inoue/.

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/