Re: Using ODBC and VBA to pull data from a large object
| От | Adam C Falkenberg |
|---|---|
| Тема | Re: Using ODBC and VBA to pull data from a large object |
| Дата | |
| Msg-id | OF53237947.096FFC59-ON85257BE9.004E48DE-85257BE9.0057245D@notes.uss.com обсуждение исходный текст |
| Ответ на | Re: Using ODBC and VBA to pull data from a large object (Bret Stern <bret_stern@machinemanagement.com>) |
| Список | pgsql-general |
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
Microsofts sample
http://support.microsoft.com/kb/258038
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
Microsofts sample
http://support.microsoft.com/kb/258038
В списке pgsql-general по дате отправления: