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

Hi,

Thanks for your great help.

With the new ODBC driver, bytea (binary) data could be fetched successfully.

Best Regards

On Tue, Feb 28, 2012 at 5:10 PM, Inoue, Hiroshi <inoue(at)tpf(dot)co(dot)jp> wrote:

> 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/<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/>
>>>> <http://www.**postgresql.org/ftp/odbc/**versions/<http://www.postgresql.org/ftp/odbc/versions/>
>>>> >.
>>>>
>>>> regards,
>>>> Hiroshi Inoue
>>>>
>>>