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.lists@xxxxxxxxxx>
To:
Adam C Falkenberg <ACFalkenberg@xxxxxxx>,
Cc:
pgsql-general@xxxxxxxxxxxxxx
Date:
09/19/2013 04:59 AM
Subject:
Re:
Using ODBC and VBA to pull data from a large object
Sent by:
pgsql-general-owner@xxxxxxxxxxxxxx
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
