From: Alanoly Andrews <alanolya@invera.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Cc: 'pgsql-general@postgresql.org' <pgsql-general@postgresql.org>
Subject: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Date: Wed, 3 Sep 2014 15:13:56 +0000
Message-ID: <6909b219ecae4d41b431efdaf6c953a3@Exch2.invera.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hello,
We have an issue with images (TIFF files) that are loaded into a postgres database table (where the image field is defined as type "lo"). The code to load the images is written in VB and the connection to the database is through postgres odbc installed on the PC. All images inserted through the VB program are retrievable also through odbc/VB, as long as the table rows at the backend are not reorganized in any way. If the table data is unloaded/reloaded or clustered (on an index) or reloaded through a pg_dump and restore, then on trying to retrieve the images, the VB program gets the error : "Multiple-step OLE DB operation generated errors. Check each OLE DB status value......etc".
The data in the backend database is still readable through other image retrieval programs connecting directly to the server (not through ODBC or VB).
The database is on an AIX server (version 6.1). Postgres version is 9.1.4.
I'd welcome any input towards the resolution of this problem.
Thanks.
Alanoly Andrews
alanolya@invera.com
________________________________
If you no longer wish to receive any of our emails, click on UNSUBSCRIBE.<mailto:unsubscribe@invera.com?subject=***Unsubscribe***> This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
Si vous ne d?sirez plus recevoir de nos courriels, veuillez appuyer sur D?SABONNEMENT.<mailto:unsubscribe@invera.com?subject=***Unsubscribe***> Ce courriel est confidentiel et prot?g?. L'exp?diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) d?sign?(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser imm?diatement, par retour de courriel ou par un autre moyen.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alanolya@invera.com, pgsql-general@postgresql.org
Subject: Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
In-Reply-To: <6909b219ecae4d41b431efdaf6c953a3@Exch2.invera.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox