blob inserted from linux not readable by MS Access - Mailing list pgsql-odbc

From Max
Subject blob inserted from linux not readable by MS Access
Date
Msg-id 20030322191450.98192.qmail@web10501.mail.yahoo.com
Whole thread Raw
List pgsql-odbc
Dear all,

I have just made a small shell script that will parse
incoming e-mail to a specific address and put some
selected parts of them into a Postgres table.
These e-mails have also binary attachments (pictures)
that I have to store together with the other e-mail
data.

I was succesfully able to perform the above tasks and
now my db gets populated by e-mails.

The problem that I'm having is that this db is
supposed to be viewed using MS Access through an
ODBC connection to the linux server (this part is
working) and I cannot avoid using Access even if I
would ;-)

The images I upload on the linux server are not
understandable by Access and the opposite, images I
upload with Access are not in any reasonable format.

It seems that Access translates them in some obscure
internal (OLE?) format.

Actually I tried detaching on the linux db server a
9894 bytes jpeg I inserted into a record from Windows
using Access and it was 551096 bytes big! but still
Access could open it and show it correctly.

So my problem is how to have Access understands the
pictures I've loaded in the db, since I'm not a db
expert I do not know how to write an Access
application that could understand them (and I actually
not like to waste time doing it).

Is there something I missed in the setup or that I
could do to improve compatibility?

Can I maybe define a default viewer for Access to use
when I double click on the OLE attachment?

I'm confused...


The blob fields are declared as type lo.
The server is PostgreSQL 7.2.2 on SuSE 8.1 (the
version on SuSE's cd) , the client Windows 2000
Professional with MS Access 2000 and PgAdminII v1.4.2

Thanks in advance,

Massimo

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com


pgsql-odbc by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Re: .ini parsing
Next
From: Doug McNaught
Date:
Subject: Re: blob inserted from linux not readable by MS Access