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

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
Subject: Re: Using ODBC and VBA to pull data from a large object
Date: 2013-09-19 08:56:51
Message-ID: 1379581011.2525.10.camel@asus-1001PX.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2013-09-19 09:32:24 the new checksum feature
Previous Message Dave Potts 2013-09-19 07:02:38 Partitioning V schema