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/