Re: lo_import doesn't works through ODBC !

I am running
PostgreSQL => 7.2.1 on RedHat 7.3
unixODBC => 2.2.4
And I beleive the psqlodbc driver that 'm using is part of the
default drivers included by unixODBC...

Should i download and compile a newer version of unixODBC or
the psqlodbc driver from the postgresql.org ?

I am stuck coz of this ! Otherwise is it possible to store binary
data straight in to the database without lo_import/lo_export ?
I couldn't find any proper literature yet to achieve this. Seems
bytea does this and i should filter some escape sequences to
achieve binary data storage.....

It wld be great if i can get some help here !

Regards
- Sudhir

-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
Sent: Monday, April 14, 2003 8:27 AM
To: Sudhir S, Noida
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] lo_import doesn't works through ODBC !

"Sudhir S, Noida" wrote:
>
> I am successful by trying the following SQL statement in the psql
prompt.
> INSERT INTO image (name, raster)
> VALUES ('myimg', lo_import('/var/lib/pgsql/CmpJpg.jpg'));
>
> Through the psql interface this works properly and i have tried the
> same using the UnixODBC's isql interface as well which again works
> perfectly.
>
> The problem is, the same SQL statement doesn't works through ODBC, I
have
> no clues why it doesn't ? And when i tried to debug the application
> at some point of time i can notice that "Error while executing the Query
> (non-fatal)" and the return value is STMT_INFO_ONLY
>
> Any inputs on this problem would be hightly appreciated..

You seem to be using a pretty old driver.

regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/