From: Carolyn Lu Wong <carolyn@greatpacific.com.au>
To: Kardos, Dr. Andreas <kardos@repas-aeg.de>
To: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: Re: ODBC question
Date: Thu, 29 Jun 2000 12:00:00 +1000
Message-ID: <395AADA0.43573323@greatpacific.com.au> (raw)
References: <3959F24C.88D772B6@greatpacific.com.au>
<010701bfe106$1763c0d0$99301eac@Dr.repas.de>
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?
> >
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: carolyn@greatpacific.com.au, kardos@repas-aeg.de
Subject: Re: ODBC question
In-Reply-To: <395AADA0.43573323@greatpacific.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox