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: 3BDDF6C3.668DD2C4@tpf.co.jp (view raw or flat)
Thread:
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.

regards,
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-2014 The PostgreSQL Global Development Group