From: | "Luc ROLLAND" <luc(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 10:05:32 |
Message-ID: | 006301c49fc2$88a62c40$0a00a8c0@lrp43008 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Shachar Shemesh | 2004-09-21 11:47:17 | Re: OIDS column required with ODBC ? |
Previous Message | Philippe Lang | 2004-09-21 09:57:15 | Re: OIDS column required with ODBC ? |