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@xxxxxxxxxxxxxxxxxxxxx>
To:
Adam C Falkenberg <ACFalkenberg@xxxxxxx>,
Cc:
pgsql-general@xxxxxxxxxxxxxx
Date:
09/17/2013 10:06 AM
Subject:
Re:
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
