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@machinemanagement.com> To: Adam C Falkenberg <ACFalkenberg@uss.com>, Cc: pgsql-general@postgresql.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
