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

Re: OIDS column required with ODBC ?

From: Secrétariat <ets(at)rolland-fr(dot)com>
To: "ODBC PostgreSQL" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: OIDS column required with ODBC ?
Date: 2004-09-21 18:41:27
Message-ID: 002401c4a00a$9b610380$0a00a8c0@lrp43008 (view raw or flat)
Thread:
Lists: pgsql-odbc
I use the Open Method from ADO in MS Visual-Basic 6.0 ...
Is there anybody who can explain to me why I can't open tables without OIDS 
?

 Thanks.

 Luc

> ----- Original Message ----- 
> 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>
> Sent: Tuesday, September 21, 2004 11:57 AM
> Subject: Re: [ODBC] OIDS column required with 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 


Responses

pgsql-odbc by date

Next:From: SecrétariatDate: 2004-09-22 14:09:11
Subject: Re: OIDS column required with ODBC ?
Previous:From: Shachar ShemeshDate: 2004-09-21 11:47:17
Subject: Re: OIDS column required with ODBC ?

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