Re: ADO-Error when inserting row with text column with large text

Hello Hiroshi,

much thanks to you !!!!!!!

Adding MaxLongVarcharSize=nnn and TextAsLongVarchar=1 to the connection string works perfect !

mit freundlichen Grüßen / best regards,

Josef Springer

(Geschäftsleitung/Management)

Address

Josef(dot)Springer(at)joops(dot)com

Orlando-di-Lasso Str. 2

D-85640 Putzbrunn

Office

+49 (0)89 600 6920

Fax

+49 (0)89 600 69220

Web

http://www.joops.com

(HRB München 86239)

-- the software company --

On 15.06.2013 00:01, Hiroshi Inoue wrote:

(2013/06/15 0:13), Hiroshi Inoue wrote:

(2013/06/14 23:49), Josef Springer wrote:

Hi Hiroshi,

thanks for your hint.

But where to change *MaxLongVarcharSize* ?

I open the recordset with

/Open( "select * from table", activeConnection: "Driver={PostgreSQL

Unicode};Server=localhost;Uid=uid;Pwd=pwd;Database=database" )/

Add ;MaxVarcharSize=xxxxxx to your connection string.

The default is 8190.

Please also try to add

TextAsLongVarchar=1

option to your connection string.

regards,

Hiroshi Inoue