> -----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.

Regards, Dave.

Responses

• Re: int8 defined as text in MS Access? at 2002-05-20 06:48:05 from Hiroshi Inoue

pgsql-odbc by date

Next:	From: Henshall, Stuart - WCP	Date: 2002-05-17 10:16:12
	Subject: Re: int8 defined as text in MS Access?
Previous:	From: Patrick Hatcher	Date: 2002-05-16 22:22:27
	Subject: int8 defined as text in MS Access?