Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group