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

From: apollo(at)enigma(dot)net
To: pgsql-interfaces(at)postgresql(dot)org
Date: 1999-07-15 11:14:29
Message-ID: (view raw or whole 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

Read onlys

Any ideas would be appreciated.

Don Youdale                                 Enigma Software

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-2015 The PostgreSQL Global Development Group