Skip site navigation (1) Skip section navigation (2)

From: apollo(at)enigma(dot)net
To: pgsql-interfaces(at)postgresql(dot)org
Subject:
Date: 1999-07-15 11:14:29
Message-ID: 3.0.3.32.19990715171429.00932bb0@enigma.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)enigma(dot)net                     http://www.enigma.net
-----------------------------------------------------------

pgsql-interfaces by date

Next:From: apolloDate: 1999-07-15 11:45:35
Subject: Oops. Forgot log and source....
Previous:From: Moray McConnachieDate: 1999-07-15 07:40:50
Subject: SELECT... INTO via ODBC

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