Re: Access97/odbcUnicode/pgsql : unable to map text field - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Access97/odbcUnicode/pgsql : unable to map text field
Date
Msg-id 20060609135030.GA18181@soptik.pzkagis.cz
Whole thread Raw
In response to Re: Access97/odbcUnicode/pgsql : unable to map text field  (JGuillaume 'IoGuiX' de Rorthais <igxnews@free.fr>)
Responses Re: Access97/odbcUnicode/pgsql : unable to map text field  (JGuillaume 'IoGuiX' de Rorthais <igxnews@free.fr>)
Re: Access97/odbcUnicode/pgsql : unable to map text field  ("Bronto" <brontos@hotpop.com>)
List pgsql-odbc
> Mh, looks impossible to join just a .exe without a part of Office pack :/

It's a pity.

> I just have my logs for you...
>
> Anyway, indeed, mapping PgSQL Text type to Access Memo work fine with
> the ANSI's
> ODBC versions. But using the ANSI version require to much macro & VBA stuff
> to
> workaround the #Deleted behaviour (that is an Access specific problem).

The only difference I see is in type of 'txt' column.
ANSI:    SQL_LONGVARCHAR  (-1)
Unicode: SQL_WLONGVARCHAR (-10)

Let's try change Max Longvarchar size from 8190 to something higher
(at least 16380). If it doesn't help try change the Max Longvarchar
size to -4 (SQL_NO_TOTAL).

Maybe it helps or maybe it doesn't.

Regards,

Luf

pgsql-odbc by date:

Previous
From: JGuillaume 'IoGuiX' de Rorthais
Date:
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field
Next
From: JGuillaume 'IoGuiX' de Rorthais
Date:
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field