From: apollo@enigma.net
To: pgsql-interfaces@postgresql.org
Date: Thu, 15 Jul 1999 17:14:29 +0600
Message-ID: <3.0.3.32.19990715171429.00932bb0@enigma.net> (raw)
Running a small VB app within MS Access 97 to copy data using DAO.
ODBC 6.40.0006
PSQL 6.5
Client: Win NT
PostgreSQL DB opens fine. Can link tables as a test and they are updatable.
I open the recordset (cursor) as a dynaset type (keyset) and get the
following error upon executing a '.AddNew' method on the recordset.
"Cursor is not valid"
Have tried different combinations of ODBC driver settings including
defaults plus:
Rec Unique Index
Use Declare/Fetch
Parse Statements
minus:
Read onlys
Any ideas would be appreciated.
-----------------------------------------------------------
Don Youdale Enigma Software
apollo@enigma.net http://www.enigma.net
-----------------------------------------------------------
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: apollo@enigma.net
Subject: Re:
In-Reply-To: <3.0.3.32.19990715171429.00932bb0@enigma.net>
* 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