Re: error message "column "oid" doesn't exist"

From: "Erika Marlow" <Erika(dot)Marlow(at)nisc(dot)coop>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: error message "column "oid" doesn't exist"
Date: 2007-01-02 18:00:09
Message-ID: 8388742B98C6BE479282C543CD000EE003C11A20@ndes1.nisc.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

We are recieving the error message "column "oid" doesn't exist" from a
series of ODBC calls via ADO in a Visual Basic application. The SQL
statements are all "SELECT * FROM <table>" where <table> refers to
several different tables. No tables were created with OIDs, because we
don't use them. So, the statement in the error is true, but we've been
using the same application without issues for quite some time.

We're still using the 8.01.0200 drivers, UNICODE in this particular
case, and if necessary can upgrade (but it's a painful process).

Any suggestions for resolving the issue without updating to the latest
drivers?

If updating is the only option, do the new installation packages for the
driver take care of any ANSI/UNICODE differences? What are the rules
for moving from one to the other?

Thanks,

<http://www.nisc.coop/> Erika Marlow___________________
Senior Software Specialist
National Information Solutions Cooperative
One Innovation Circle
Lake St. Louis, MO 63367
**Email: erika(dot)marlow(at)nisc(dot)coop <mailto:erika(dot)marlow(at)nisc(dot)coop>
**Phone: 866.WWW.NISC (866.999.6472)
**Direct: 636.755.2519

Browse pgsql-odbc by date

  From Date Subject
Next Message Arnaud Lesauvage 2007-01-04 14:02:52 Slow query : join between jet and postgresql table
Previous Message noreply 2007-01-02 17:32:14 [ psqlodbc-Bugs-1001172 ] Problem with ADO.RecordCount