Hello,
No, you don't need to use OIDs with the ODBC driver. I alway create tables WITHOUT OIDS, and I can access them through
ODBCwith MS Access without any problem.
But I'm sorry I cannot tell you the reason of your error message...
Hope it will help you anyway.
Philippe
________________________________
De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de Luc ROLLAND
Envoyé : mardi, 21. septembre 2004 11:48
À : ODBC PostgreSQL
Objet : [ODBC] OIDS column required with ODBC ?
Hello !
I want to open a recordset using ODBC (07_03_0200) in MS-VB6 (SP6) on a PG table (7.4.3) created WITHOUT OIDS.
I receive an error message : 'Colum ?id? doesn't exist !' when I use the method Open ?
The same code works if the table has an OID column.
Would pgsqlODBC require an OIDS column on all the tables ?
I don't find setting for that in the ODBC driver...
Luc