Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 14A722E003D for ; Sun, 15 Jun 2008 00:39:42 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53194-06 for ; Sun, 15 Jun 2008 00:39:31 -0300 (ADT) X-Greylist: delayed 00:05:56.759422 by SQLgrey-1.7.6 Received: from xigix.ioguix.net (ioguix.net [217.70.191.109]) by developer.postgresql.org (Postfix) with ESMTP id DEB542E0038 for ; Sun, 15 Jun 2008 00:39:31 -0300 (ADT) Received: from [192.168.1.103] (adsl-216-246-224-133.erx01.mtlcnds.ext.distributel.net [216.246.224.133]) by xigix.ioguix.net (Postfix) with ESMTPSA id 49AF831CD2; Sun, 15 Jun 2008 05:33:24 +0200 (CEST) Message-ID: <48548ECB.1070700@free.fr> Date: Sat, 14 Jun 2008 23:38:51 -0400 From: "JGuillaume (ioguix) de Rorthais" User-Agent: Mozilla-Thunderbird 2.0.0.14 (X11/20080509) MIME-Version: 1.0 To: C K CC: "pgsql-admin@postgresql.org" Subject: Re: Storing images and other data in PostgreSQL from Ms Access References: In-Reply-To: X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200806/117 X-Sequence-Number: 29455 -----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 ANSI driver...at least, TEXT -> Memo, so I probably linked bytea -> OLE using the ANSI driver when I tried ? - -- Guillaume (ioguix) de Rorthais C K a écrit : > 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 the data. > What to do? As per my knowledge postgresql adds some bytes to the > binary data to be uploaded. I have eralier used mysql and it work > well. Is there any solution for this? > > Please help. > I am using Postgresql 8.3.1 and unicode driver with MS Access 2003 > and most current patches from microsoft applied on Windows Xp. > > Thanks > CPK > > -- > Keep your Environment clean and green. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFIVI7KxWGfaAgowiIRAhwLAJoCIPP6kWoZGsvdNJvkKx38xIUtaQCeKYrk ah6gAsw1uMVhqFENBhgR9jk= =agg/ -----END PGP SIGNATURE-----