Re: 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/