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

Thanks for the response. The example you sent is what I tried to follow
when I originally worked on this. It works great for the first 255 bytes,
but after that it returns 0's. Is there any way to get all of the data in
a large object returned to a recordset (not just the first 255 bytes)?
Thanks again.

Adam C. Falkenberg
Quality Engineer
Great Lakes Works
Phone: (313) 749 - 3758
Cell: (313) 910 - 3195

From: Bret Stern <bret_stern(at)machinemanagement(dot)com>
To: Adam C Falkenberg <ACFalkenberg(at)uss(dot)com>,
Cc: pgsql-general(at)postgresql(dot)org
Date: 09/17/2013 10:06 AM
Subject: Re: [GENERAL] Using ODBC and VBA to pull data from a large
object

On Tue, 2013-09-17 at 08:32 -0400, Adam C Falkenberg wrote:
> Good Morning,
>
> I had a question about using ODBC with large objects. When I query
> the pg_largeobject table and return data to an ADO recordset, I can
> only get the first 255 bytes even though the record contains 2048
> bytes of data (all the bytes after the first 255 show as 0). When I
> checked the type of the record, it was a VarBinary. Is there a way to
> have all of the data returned to the recordset? Thanks for any help.
>
> Adam

Microsofts sample
http://support.microsoft.com/kb/258038