lo_import doesn't works through ODBC !

From: "Sudhir S, Noida" <sudhirs(at)noida(dot)hcltech(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: lo_import doesn't works through ODBC !
Date: 2003-04-13 18:22:53
Message-ID: E04CF3F88ACBD5119EFE00508BBB212108ACFAA5@exch-01.noida.hcltech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Daniel F Garcia 2003-04-13 21:54:07 Re: Connection to posgresql database works under windows scripting host but not IIS/ASP
Previous Message Sudhir S, Noida 2003-04-13 18:21:40 Storing Binary Data to PostgreSQL Database through ODBC Interface