Skip site navigation (1) Skip section navigation (2)

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

From: Ganesh Borse <bganesh05(at)gmail(dot)com>
To: "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Request for help on retrieving binary data from bytea column using ODBC calls
Date: 2012-02-29 04:52:02
Message-ID: CAEhYC0Gi=n69kuJqoh5WTBjDxeFuCCyYfYG-eMVe7eJmQC0xvQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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
>>>>
>>>

In response to

pgsql-odbc by date

Next:From: marianDate: 2012-03-04 07:21:18
Subject: hang at SQLAllocStmt
Previous:From: Inoue, HiroshiDate: 2012-02-28 09:10:48
Subject: Re: Request for help on retrieving binary data from bytea column using ODBC calls

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group