Re: DAO VB ODBC "read only problems

"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