Received: from gwineta.repas.de (gwineta.repas.de [193.101.49.1])
	by hub.org (8.10.1/8.10.1) with ESMTP id e5T9CH134441
	for <pgsql-interfaces@postgresql.org>;
	Thu, 29 Jun 2000 05:12:18 -0400 (EDT)
Received: (from smap@localhost) by gwineta.repas.de (8.8.8/8.8.8) id LAA13436
	for <pgsql-interfaces@postgresql.org>; Thu, 29 Jun 2000 11:12:12 +0200
Received: from dragon.dr.repas.de(172.30.48.206) by gwineta.repas.de via smap
	(V2.1) id xma013379; Thu, 29 Jun 00 11:11:05 +0200
Received: from kardos.dr.repas.de ([172.30.48.153])
	by dragon.dr.repas.de (UCX V4.2-21C, OpenVMS V6.2 Alpha);
	Thu, 29 Jun 2000 11:12:26 +0200
Message-ID: <01af01bfe1a9$f8ec94c0$99301eac@Dr.repas.de>
From: "Kardos, Dr. Andreas" <kardos@repas-aeg.de>
To: "Carolyn Lu Wong" <carolyn@greatpacific.com.au>
Cc: <pgsql-interfaces@postgresql.org>
References: <3959F24C.88D772B6@greatpacific.com.au>
	<010701bfe106$1763c0d0$99301eac@Dr.repas.de>
	<395AADA0.43573323@greatpacific.com.au>
Subject: Re: ODBC question
Date: Thu, 29 Jun 2000 11:11:11 +0200
Organization: repas AEG Automation GmbH
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Archive-Number: 200006/130

With DAO this is the same story, but in the Workspace object:

WS.DefaultCursorDriver = dbUseODBCCursor

-----Ursprüngliche Nachricht-----
Von: Carolyn Lu Wong <carolyn@greatpacific.com.au>
An: Kardos, Dr. Andreas <kardos@repas-aeg.de>;
<pgsql-interfaces@postgresql.org>
Gesendet: Donnerstag, 29. Juni 2000 04:00
Betreff: Re: [INTERFACES] ODBC question


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?
> >