Re: Using ODBC and VBA to pull data from a large object

I'm using Excel. I needed to set the MAXVARCHARSIZE parameter in the
connection string to take care of my issue (MAXVARCHARSIZE=2048 for me).
That allowed the defined size of the field to equal the actual size.
Thanks everyone for your help!

Adam

From: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
To: Adam C Falkenberg <ACFalkenberg(at)uss(dot)com>,
Cc: pgsql-general(at)postgresql(dot)org
Date: 09/19/2013 04:59 AM
Subject: Re: [GENERAL] Using ODBC and VBA to pull data from a large
object
Sent by: pgsql-general-owner(at)postgresql(dot)org

Le mardi 17 septembre 2013 à 12:25 -0400, Adam C Falkenberg a écrit :
> Sorry about that. Here's the driver information and some code.

> Driver Name: PostgreSQL ANSI
> Version: 9.02.01.00
>
> constr = "Driver={PostgreSQL ANSI}; Server=servername; Port=5432;
> Database=databasename; Uid=username; Pwd=password;"
> With conn
> .ConnectionString = (constr)
> .Open
> End With
>
> SQL = "SELECT data FROM pg_largeobject WHERE loid = " & id & " ORDER
> BY pageno"
> rs.Open SQL, conn
>
> stream.Type = adTypeBinary
> stream.Open
>
> ' Loop through the recordset and write the binary data to the stream
> While Not rs.EOF
> stream.Write rs.Fields("data").Value
> rs.MoveNext
> Wend

You don't say where you use that recordset (Excel, Access?)

A google search will return several discussions about this problem; here
is an example :

http://social.msdn.microsoft.com/Forums/en-US/32b64a3f-3e7a-4e02-a7ef-824cacfea57a/256-char-limit-on-ado-recordset-field

--
Salutations, Vincent Veyron
http://gdlc.fr/logiciels
Applications de gestion des contentieux juridiques et des dossiers de
sinistres assurance