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@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