From: | "Sudhir S, Noida" <sudhirs(at)noida(dot)hcltech(dot)com> |
---|---|
To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: lo_import doesn't works through ODBC ! |
Date: | 2003-04-14 10:52:36 |
Message-ID: | E04CF3F88ACBD5119EFE00508BBB212108B3B0A2@exch-01.noida.hcltech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I am running
PostgreSQL => 7.2.1 on RedHat 7.3
unixODBC => 2.2.4
And I beleive the psqlodbc driver that 'm using is part of the
default drivers included by unixODBC...
Should i download and compile a newer version of unixODBC or
the psqlodbc driver from the postgresql.org ?
I am stuck coz of this ! Otherwise is it possible to store binary
data straight in to the database without lo_import/lo_export ?
I couldn't find any proper literature yet to achieve this. Seems
bytea does this and i should filter some escape sequences to
achieve binary data storage.....
It wld be great if i can get some help here !
Regards
- Sudhir
-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
Sent: Monday, April 14, 2003 8:27 AM
To: Sudhir S, Noida
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Hollysugar Webmaster | 2003-04-14 14:34:02 | Re: doubt |
Previous Message | Miguel Juan | 2003-04-14 08:28:54 | Re: doubt |