Re: Request for help on retrieving binary data from bytea column using ODBC calls - Mailing list pgsql-odbc

From Ganesh Borse
Subject Re: Request for help on retrieving binary data from bytea column using ODBC calls
Date
Msg-id CAEhYC0Gi=n69kuJqoh5WTBjDxeFuCCyYfYG-eMVe7eJmQC0xvQ@mail.gmail.com
Whole thread Raw
In response to Re: Request for help on retrieving binary data from bytea column using ODBC calls  ("Inoue, Hiroshi" <inoue@tpf.co.jp>)
List 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@tpf.co.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@gmail.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@tpf.co.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

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: Request for help on retrieving binary data from bytea column using ODBC calls
Next
From: marian@byteanywhere.com
Date:
Subject: hang at SQLAllocStmt