Skip site navigation (1) Skip section navigation (2)

Re: DAO VB ODBC "read only problems

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: "Miller, Sam" <sam(dot)miller(at)intel(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: DAO VB ODBC "read only problems
Date: 2001-10-30 00:39:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
"Miller, Sam" wrote:
> Folks,
> I am having great difficulty getting a VB script (Excel) to talk to a linux
> based PostgreSQL server.  I can read data just fine but get the following
> error when I try to edit:
> Next line produces error:
> Run-time error '3027';
> Connot update. Database or object is read-only
> I have done the following so far:
> 1. Created a table with a "PRIMARY KEY" as:
> CREATE TABLE data2 (
>  x integer,
>  y integer,
>  symbol varchar(15),
>  pin varchar(15) primary key);
> 2. Made sure that the select statement does not end in a semi-colon.
> 3. Created the following table (don't think this is necessary).. but I saw
> something that mentioned it:
> CREATE TABLE "msysconf" (
> "config" int2 NOT NULL,
> "chvalue" character varying,
> "nvalue" int4,
> "comments" character varying);
> 4. Verified that the "read only" check box is not checked in the PostgreSQL
> ODBC Advanced Options
> 5. Checked both "show columns" and "fake index" in the OID options section
> of the Data Source advanced options.
> 6. Tried dbOpenSnapshot option (??? static cursor) on the OpenRecordset
> method (also tried without).
> I don't know what else to try,
> Anyone have any ideas? (VB code below)

Unfortunately psqlodbc driver doesn't implement updatable
cursors. Probably you have to set DefaultCursorDriver property
of the ODBCDirect workspace as dbUseODBCCursor.

Hiroshi Inoue

In response to

pgsql-interfaces by date

Next:From: Miller, SamDate: 2001-10-30 06:43:26
Subject: Re: DAO VB ODBC "read only problems
Previous:From: Ross J. ReedstromDate: 2001-10-29 23:34:28
Subject: Re: DAO VB ODBC "read only problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group