ODBC 07.03.0100 Incorrect mapping of Int8 fields in Access

From: Corrado Cavallini <ccavalli(at)baan(dot)com>
To: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC 07.03.0100 Incorrect mapping of Int8 fields in Access
Date: 2003-05-27 16:39:29
Message-ID: FB28BEFE574F5A4F8D00851843A258EC8AAD68@ex-nld-u1.baan.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

ODBC driver version 07.03.0100
PostgreSQL database version 7.3.1

After having updated to the latest I found that I cannot no more read files
containing an Int8 fields in a primary key using Access 2002.
I could still use those files with the legacy driver version.

Is easy to recreate the error:

1)Create a simple table:
CREATE TABLE public._test (
col1 int8 NOT NULL,
col2 varchar(50) NOT NULL,
CONSTRAINT _test_pkey PRIMARY KEY (col1, col2)
) WITH OIDS;
2) manually fill some records
3) open an empty access 2000 database
4) create 2 ODBC DNS using the last and the legacy driver
5) link the table twice, with the two different DNS
6) the table linked with odbc legacy is visible
7) the other give You an error

I have noted that if You look at the design of the linked table, the Int8
column is mapped to "Text 255" while in the legacy is mapped to "Text 19" so
I suspect that the total lenght of the primary key exceed some limit.

Hope this could help

Regards
Corrado Cavallini

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Nisha Joseph 2003-05-28 12:08:46 Large Objects
Previous Message a.hitter 2003-05-27 07:38:58 select between two databases