Received: from hotmail.com (oe29.law3.hotmail.com [209.185.240.22]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB4KK8G29869 for ; Mon, 4 Dec 2000 15:20:08 -0500 (EST) (envelope-from npdavis@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 4 Dec 2000 12:20:28 -0800 X-Originating-IP: [206.197.57.49] From: "Neil Davis" To: "Evelio Martinez" Cc: References: <3A2BE607.4C268EA6@testanet.com> Subject: Re: PostgreSQL ODBC driver: recordset not updatable Date: Mon, 4 Dec 2000 15:18:57 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: X-OriginalArrivalTime: 04 Dec 2000 20:20:28.0798 (UTC) FILETIME=[A4D091E0:01C05E2F] X-Archive-Number: 200012/24 X-Sequence-Number: 361 Evelio, ODBC drivers on Micro$oft windows, typically do not support update, delete or insert (db modification) through them when used against non-microsoft databases. Part of the price you pay for ODBC. You will have to write server side functions and execute them through the odbc connections like: cnn_postgresql_ado_connection.Execute("SELECT function_name('" + arg1 + "', '" + arg2 + "', '" + arg3 + "');") using vba. Try all three types of query before writing lots of functions. ODBC may support some of them. You simply write a parameterized function. In this function you put your update, insert, or delete query. When you execute through ODBC it will work. Details are in the PostGreSQL online manual. Get the searchable PDF that Bruce Momjian is writing. It is excellent. It got me through 90% of the platform specific stuff that I needed to learn. L8, Neil ----- Original Message ----- From: "Evelio Martinez" To: Sent: Monday, December 04, 2000 1:44 PM Subject: [INTERFACES] PostgreSQL ODBC driver: recordset not updatable > > > Hi! > > I have installed the postgresql ODBC driver (6.5) under W98 and I am > trying to access the PostgreSQL 7.0.2 database on Linux > but I cannot edit or modify the data from MS Access 2000. > > The Readonly check box is not marked, so ? > > Is this a bug ? > Are the components incompatible? > > Any help will be appreciated. > > Evelio > >