From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Sudhir S, Noida" <sudhirs(at)noida(dot)hcltech(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: lo_import doesn't works through ODBC ! |
Date: | 2003-04-14 02:57:28 |
Message-ID: | 3E9A2398.5F70C14C@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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/
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2003-04-14 03:11:05 | Re: Parse Statement causes a "hang" in crystal reports |
Previous Message | Daniel F Garcia | 2003-04-13 21:54:07 | Re: Connection to posgresql database works under windows scripting host but not IIS/ASP |