Received: from kss.net.au ([203.41.122.41])
	by hub.org (8.10.1/8.10.1) with ESMTP id e5T1v6104968
	for <pgsql-interfaces@postgresql.org>;
	Wed, 28 Jun 2000 21:57:06 -0400 (EDT)
Received: from greatpacific.com.au (coco [10.10.1.9])
	by kss.net.au (8.8.7/8.8.7) with ESMTP id MAA04914;
	Thu, 29 Jun 2000 12:00:03 +1000
Message-ID: <395AADA0.43573323@greatpacific.com.au>
Date: Thu, 29 Jun 2000 12:00:00 +1000
From: Carolyn Lu Wong <carolyn@greatpacific.com.au>
Organization: Great Pacific Financial Group
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: "Kardos, Dr. Andreas" <kardos@repas-aeg.de>,
	"pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Subject: Re: ODBC question
References: <3959F24C.88D772B6@greatpacific.com.au>
	<010701bfe106$1763c0d0$99301eac@Dr.repas.de>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200006/124

I'm using DAO, not RDO, create record sets as follows:

Set WS = DBEngine.CreateWorkspace("MainWS", "user", vbNullString,
dbUseODBC)
Set CN = WS.OpenConnection("", dbDriverNoPrompt, False, strConnect)
Set RS = CN.OpenRecordset(strSQL, dbOpenDynaset, dbExecDirect,
dbOptimistic)

where WS, CN and RS are defined as workspace, connection and recordset.


"Kardos, Dr. Andreas" wrote:
> 
> Set the CurserDriver Property of the Connection Object to rdUseOdbc.
> 
> Andreas Kardos
> 
> -----Ursprüngliche Nachricht-----
> Von: Carolyn Lu Wong <carolyn@greatpacific.com.au>
> An: <pgsql-interfaces@postgresql.org>
> Gesendet: Mittwoch, 28. Juni 2000 14:40
> Betreff: [INTERFACES] ODBC question
> 
> > hi
> >
> > I'm writing client application with VB5 which connects to PostgreSQL via
> > PsqlODBC.
> >
> > When I select a set of data with RecordSet from VB, I can't seem to
> > update the record set and has the following error message:
> >
> > S1C00: Onlye SQL_POSITION/REFRESH is supported for SQLSetPos.
> >
> > Any idea?
> >