lo_import doesn't works through ODBC !
От | Sudhir S, Noida |
---|---|
Тема | lo_import doesn't works through ODBC ! |
Дата | |
Msg-id | E04CF3F88ACBD5119EFE00508BBB212108ACFAA5@exch-01.noida.hcltech.com обсуждение исходный текст |
Список | pgsql-odbc |
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.. Regards - Sudhir -- Disclaimer: This document is intended for transmission to the named recipient only. If you are not that person, you should note that legal rights reside in this document and you are not authorized to access, read, disclose, copy, use or otherwise deal with it and any such actions are prohibited and may be unlawful. The views expressed in this document are not necessarily those of HCL Technologies Ltd. Notice is hereby given that no representation, contract or other binding obligation shall be created by this e-mail, which must be interpreted accordingly. Any representations, contractual rights or obligations shall be separately communicated in writing and signed in the original by a duly authorized officer of the relevant company.
В списке pgsql-odbc по дате отправления: