Thread: 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...
I don't find setting for that in the ODBC driver...
Luc
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
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.lang@attiksystem.ch> To: "Luc ROLLAND" <luc@rolland-fr.com>; "ODBC PostgreSQL" <pgsql-odbc@postgresql.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@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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Luc ROLLAND wrote:
> 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
>
Try defining the table as static readonly, and see if that helps.
Shachar
--
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/
For information : It's a cursor side problem ! By default MS-VB6 use "server side cursor" only alowing Open in "Static mode" with "Pessimistic Lock". Setting "CursorLocation=adUseClient" use "client side cursor" alowing Open in "Dynamic mode" with "Optimistic Lock". Hard work !... Luc >> 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 >> > Try defining the table as static readonly, and see if that helps. > > Shachar > > -- > Shachar Shemesh > Lingnu Open Source Consulting ltd. > http://www.lingnu.com/ > >