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

Re: OIDS column required with ODBC ?

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Luc ROLLAND" <luc(at)rolland-fr(dot)com>,"ODBC PostgreSQL" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: OIDS column required with ODBC ?
Date: 2004-09-21 09:57:15
Message-ID: 6C0CF58A187DA5479245E0830AF84F42142B95@poweredge.attiksystem.ch (view raw or flat)
Thread:
Lists: pgsql-odbc
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 ODBC with 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(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)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



Responses

pgsql-odbc by date

Next:From: Luc ROLLANDDate: 2004-09-21 10:05:32
Subject: Re: OIDS column required with ODBC ?
Previous:From: Luc ROLLANDDate: 2004-09-21 09:47:41
Subject: OIDS column required with ODBC ?

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