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

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
Subject: Re: Using ODBC and VBA to pull data from a large object
Date: 2013-09-17 14:06:14
Message-ID: 1379426774.2677.0.camel@centos-dev.machinemanagement.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-09-17 14:46:28 Re: using Replace funcion in postgresql
Previous Message Albe Laurenz 2013-09-17 13:22:01 Re: need a hand with my backup strategy please...