Re: [ADMIN] Storing images and other data in PostgreSQL from Ms Access

2008-06-15 Thread C K
No need to do it. On the web I found a article which states to use the data type 'lo' rather than 'bytea' and after refreshing the link works well. No problem faced. tested with MS access 2003 and 2007. Thanks to community. CPK On Sun, Jun 15, 2008 at 9:08 AM, JGuillaume (ioguix) de Rorthais < [EM

Re: [ADMIN] Storing images and other data in PostgreSQL from Ms Access

2008-06-14 Thread JGuillaume (ioguix) de Rorthais
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 *IIRC*, using bytea type works like a charm for OLE stuff from MS Access... Try to link your tables with the ANSI driver, then change the ODBC source to the UNICODE one. I don't know why, but ISTM that MSAccess perform a better type mapping with the A

[ADMIN] Storing images and other data in PostgreSQL from Ms Access

2008-06-14 Thread C K
Hi All, I am testing the postgresql as a back-end for a project having ms access as a front-end. I have linked postgresql tables and started using. It works well for all data except the binary data. When used to insert/retrieve data from such fields, ms access gives error that it can't recognize th