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

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 (view raw or flat)
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

pgsql-odbc by date

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

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