Re: ODBC 07.03.0100 Incorrect mapping of Int8 fields in Ac

Hiroshi Inoue wrote:

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

Changing the INT8 AS option has no effect on version 07.03.0100.

BUT, I could confirm that using the snapshot version 07.03.0107 with:

1)  "INT8 AS default" the field is mapped in Access 2002 as "Numeric" of
type "Decimal" Size 19 Scale 0.

2) "INT8 AS varchar" the field is mapped in Access 2002 as "Text" Size 19,
that was the behaviour of the legacy driver.

In both cases no errors are returned.

Excellent
Regards

Corrado Cavallini

-----Original Message-----
From: Hiroshi Inoue
To: Corrado Cavallini
Cc: 'pgsql-odbc@postgresql.org'
Sent: 02/06/2003 1.52
Subject: Re: [ODBC] 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/