Re: int8 defined as text in MS Access?

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, Patrick Hatcher <PHatcher(at)macys(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: int8 defined as text in MS Access?
Date: 2002-05-20 06:48:05
Message-ID: 3CE89C25.F60BA235@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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/

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Jean-Michel POURE 2002-05-20 07:31:31 Re: [HACKERS] UTF-8 safe ascii() function
Previous Message Patrice Hédé 2002-05-19 19:14:42 Re: [HACKERS] UTF-8 safe ascii() function