X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 314E392510C; Wed, 28 May 2003 08:08:51 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 14319-07; Wed, 28 May 2003 08:08:47 -0400 (EDT) Received: from hotmail.com (f45.law12.hotmail.com [64.4.19.45]) by developer.postgresql.org (Postfix) with ESMTP id 332409251D9; Wed, 28 May 2003 08:08:46 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 28 May 2003 05:08:46 -0700 Received: from 134.83.1.225 by lw12fd.law12.hotmail.msn.com with HTTP; Wed, 28 May 2003 12:08:46 GMT X-Originating-IP: [134.83.1.225] X-Originating-Email: [nishatreesa@hotmail.com] From: "Nisha Joseph" To: pgsql-odbc@postgresql.org, pgsql-interfaces@postgresql.org Subject: Large Objects Date: Wed, 28 May 2003 12:08:46 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 28 May 2003 12:08:46.0976 (UTC) FILETIME=[E4338800:01C32511] X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/84 X-Sequence-Number: 4202 Hi, My application ,written in VC++ requires to copy data in a Microsoft Access Database to Postgres database,remotely. I have been using odbc Driver 7.02.005 with Postgresql 7.3.2 . I need to transfer photographs stored as OLEObjecttype in a Microsoft Aceess 2000 database to the Postgres database.Right now I am using bytea type for storing photographs in the Postgresql database. I want to store the photographs as Large Objects in the Postgres database. Can anyone please help me regarding this?Can you provide with sample code for this? Thanks in Advance Nisha _________________________________________________________________ Sign-up for a FREE BT Broadband connection today! http://www.msn.co.uk/specials/btbroadband