Re: DAO VB ODBC "read only problems - Mailing list pgsql-interfaces

From Hiroshi Inoue
Subject Re: DAO VB ODBC "read only problems
Date
Msg-id 3BDF3D8E.F7E7FA7E@tpf.co.jp
Whole thread Raw
In response to Re: DAO VB ODBC "read only problems  ("Miller, Sam" <sam.miller@intel.com>)
List pgsql-interfaces
"Miller, Sam" wrote:
> 
> Hiroshi and others,
> 
> Nope....
> 
> Also tried (randomly):
> -Disabling KSQO
> -Enabling "Unknowns as LongVarChar"
> -Enabling Parse Statements
> -Enabling Show System Tables
> -Switching to 6.3 Protocol
> 

Please try 
Set rs = conSource.OpenRecordset("Select * From data2", dbOpenDynaset, _    dbExecDirect, dbOptimisticValue)
and never forget to set the DefaultCursorDriver property.

regards,
Hiroshi Inoue


pgsql-interfaces by date:

Previous
From: "Miller, Sam"
Date:
Subject: Re: DAO VB ODBC "read only problems
Next
From: Bruce Momjian
Date:
Subject: Re: ECPG - connection name in "EXEC SQL AT ... " statement