ODBC 07.03.0100 Incorrect mapping of Int8 fields in Access

Поиск
Список
Период
Сортировка
От Corrado Cavallini
Тема ODBC 07.03.0100 Incorrect mapping of Int8 fields in Access
Дата
Msg-id FB28BEFE574F5A4F8D00851843A258EC8AAD68@ex-nld-u1.baan.com
обсуждение исходный текст
Список 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

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Patrick Hatcher"
Дата:
Сообщение: Currval not working
Следующее
От: Sébastien Dehesdin
Дата:
Сообщение: Freezing with the EDB engine