Postgres Pro
Downloads
Home   >   mailing lists

Re: error message "column "oid" doesn't exist" - Mailing list pgsql-odbc

From Erika Marlow
Subject Re: error message "column "oid" doesn't exist"
Date
Msg-id 8388742B98C6BE479282C543CD000EE003C11A20@ndes1.nisc.lan
Whole thread Raw
List pgsql-odbc
Tree view
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,
 
Erika Marlow___________________
Senior Software Specialist
National Information Solutions Cooperative
One Innovation Circle
Lake St. Louis, MO 63367
+ Email: erika.marlow@nisc.coop
( Phone: 866.WWW.NISC (866.999.6472)
( Direct: 636.755.2519
 
Attachment

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1001172 ] Problem with ADO.RecordCount
Next
From: Arnaud Lesauvage
Date:
Subject: Slow query : join between jet and postgresql table