Search Postgresql Archives

Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Wed, Sep 3, 2014 at 8:13 AM, Alanoly Andrews <alanolya@xxxxxxxxxx> wrote:
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).

Are you reloading into the very same database, or into a different one? Your question doesn't make it clear. If you're loading into a new database, then one thing that comes to mind is that the bytea_output parameter in postgresql.conf might be different on the second database.

Craig

 
The database is on an AIX server (version 6.1). Postgres version is 9.1.4.
 
Id welcome any input towards the resolution of this problem.
 
Thanks.
 
Alanoly Andrews
 

  ________________________________  
If you no longer wish to receive any of our emails, click on 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. 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.



--
---------------------------------
Craig A. James
Chief Technology Officer
eMolecules, Inc.
---------------------------------

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux