Re: odbc 8.01.02 8190 bytes limitation - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: odbc 8.01.02 8190 bytes limitation
Date
Msg-id 20060425103703.GH23256@soptik.pzkagis.cz
Whole thread Raw
In response to odbc 8.01.02 8190 bytes limitation  ("Michael GUIARD" <michael@nestor-tech.com>)
List pgsql-odbc
> I use PostgreSQL database via ado (win32).
> I succeeded in storing/retrieving binary format (bytea) to/from
> database (I use it for images).
>
> But I am limited to 8190 bytes. Is it a way to disable this limitation ?

Could you try 07.03.026X version? It's enhanced experimental branch which
is now CVS tip and it'll be released as new stable release in relatively
short time. IMHO it's more stable version.

> I saw that the odbc have a MaxLongVarChar option set to 8190. May be
> my problem come from this, but how can I update this option using ado ?

There is connection string too in ADO. So specify it in it.

> I saw many posts about this subject but I did not find the
> solution - may be I am too blind today ;)

I don't want waste my time in developing dead branch (which 08.01 is).

Regards,

Luf

pgsql-odbc by date:

Previous
From: vidisha.shah@tcs.com
Date:
Subject: Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver
Next
From: Srimathi Chandrasekaran
Date:
Subject: Driver could not be loaded (0) SQLSTATE=IM002