Re: Problems with PGSQL ODBC drivers

Harry Broomhall wrote:
>
> I posted this to the general newsgroup
> 'comp.databases.postgresql.questions' a little while ago, and got no takers!
>
> <grin>
>
> As I am fairly sure this is a ODBC driver issue I am reposting it here,
> somewhat ammended, in the hope of enlightenment.
>
> ===================================
>
> I have run up against a problem trying to use the PostgreSQL ODBC
> Windows driver, and wondered if anyone can point me in the right
> direction.
>
> Basics:
>
> Server: PostgreSQL 7.2.1 on i386-unknown-freebsd4.5,
> compiled by GCC 2.95.3
>
> ODBC driver: PostgreSQL (not beta) 7.02.00.05
>
> Windows: NT4 - SP 4
>
> Excel 2000
>
> I have a view on the server from which I wish to import data into
> Excel, using MS Query.
>
> If I type the SQL query direct into MSQuery it works fine, and the
> data is fetched.
>
> If I attempt to use the MSQuery 'wizard' then when I get to 'Finish'
> and ask to return the data to Excel then I get an Error box with the
> message: "Error: No such attribute or function 'oid'". This message
> is echoed in the PostgreSQL logs.
>
> I enabled the log files in the ODBC driver, and noticed that an
> attribute 'oid' was added to the query that I would otherwise have
> expected the MSQuery app to send. AFAIK views don't have oids, so it
> would seem to me that the driver is misidentifying the view as a table
> with oids?

Please try to turn off the *Updatable cursors* DSN option.

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/