Re: Request for help on retrieving binary data from bytea column using ODBC calls

Hi,

(2012/02/28 16:00), Ganesh Borse wrote:
> Hi,
>
> I downloaded the following file& installed it.
>
> But it installed the driver in 32bit directory: C:\Program Files
> (x86)\psqlODBC\0901\bin
>
> Also, this new driver is not listed in 64-bit ODBC Data Source
> Administrator, but showing up in 32bit ODBC Data Source Administrator. (pls
> refer attached screenshot of 32& 64 bit odbc data source admin tools on
> my PC).

psqlodbc_09_01_0100-x64.zip is for 64-bit use.
psqlodbc_09_01_0100-1.zip is packaged due to a packaging mistake
of psqlodbc_09_0100.zip (32-bit version).

regards,
Hiroshi Inoue

> Thanks& Regards.
>
> On Tue, Feb 28, 2012 at 12:30 PM, Ganesh Borse<bganesh05(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> I see this version as the most recent at :
>> http://www.postgresql.org/ftp/odbc/versions/msi/
>>
>> psqlodbc_09_01_0100-1.zip 2012-01-04 00:32:34 3.7 MB
>>
>> Hopefully this is the latest one which knows about hex bytea format?
>>
>> Thanks and Regards.
>>
>>
>> On Tue, Feb 28, 2012 at 11:43 AM, Inoue, Hiroshi<inoue(at)tpf(dot)co(dot)jp> wrote:
>>
>>> (2012/02/28 11:54), Ganesh Borse wrote:
>>>
>>>> Hi,
>>>>
>>>> I am using the following PostgreSQL ODBC Windows driver:
>>>>
>>>> PostgreSQL 64bit 8.03.04.00 PSQLODBC_X64_RELEASE.DLL 8/3/2009 -- the one
>>>> which got installed with PostgreSQL 9.0 server that I downloaded from
>>>> PostgreSQL website.
>>>>
>>>
>>> Unfortunately the driver know nothing about recently introduced
>>> hex BYTEA format.
>>> Please download and install the latest version from
>>> http://www.postgresql.org/ftp/**odbc/versions/<http://www.postgresql.org/ftp/odbc/versions/>.
>>>
>>> regards,
>>> Hiroshi Inoue