Re: Need help with Visual Basic 6 and PostgreSQL

[Richard Broersma Jr <rabroersma(at)yahoo(dot)com>]

--- On Fri, 11/23/07, Finn Lassen <dcio(at)AxiomInt(dot)com> wrote:
> "ERROR: Column "oid" does not exist;"
> I get when executing the " rsOut.Open ..."
> statement below.

Here are some OID setting from ODBC driver manual:
...
OID Options:
  
Show Column: Includes the OID in SQLColumns. This is good for using as a unique identifier to update records if no good key exists OR if the key has many parts, which blows up the backend.
  
Fake Index: This option fakes a unique index on OID. This is useful when there is not a real unique index on OID and for apps which can't ask what the unique identifier should be (i.e, Access 2.0).
...

Perhaps the odbc driver defaults to showing ODBC column.  In postgresql versions < 8.0 it was the default for every table to be given an OID (basically every row in any and all tables had a unique number that identified it). However, as of postgresql 8.0, OID columns are no longer added to all table by default.  This could be causing the problem since the ODBC driver may be trying to select the OID column from your table even though it doesn't actually exist.

I will look for the ODBC documention that describes that settings that you can pass to the ODBC driver in the connection string.

Regards,
Richard Broersma Jr.