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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
-----------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | apollo | 1999-07-15 11:45:35 | Oops. Forgot log and source.... |
Previous Message | Moray McConnachie | 1999-07-15 07:40:50 | SELECT... INTO via ODBC |