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 23:53:50
Message-ID: 3BDF3D8E.F7E7FA7E@tpf.co.jp (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-interfaces by date

Next:From: Bruce MomjianDate: 2001-10-31 01:16:51
Subject: Re: ECPG - connection name in "EXEC SQL AT ... " statement
Previous:From: Ralf UllrichDate: 2001-10-30 20:36:02
Subject: Need Help with BLOBs via DBI

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