Re: ODBC 07.03.0100 Incorrect mapping of Int8 fields in Access

Corrado Cavallini wrote:
>
> 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

Please try the snapshot dll at
    http://www.geocities.jp/inocchichichi/psqlodbc/
or change the *INT8 AS" DSN option.

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/