Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Access, Views and the OID

From: Byron Nikolaidis <byron(dot)nikolaidis(at)home(dot)com>
To: Joe Shevland <shevlandj(at)kpi(dot)com(dot)au>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Access, Views and the OID
Date: 2000-03-02 03:44:21
Message-ID: 38BDE395.5D8A01C2@home.com (view raw or flat)
Thread:
Lists: pgsql-interfaces

Joe Shevland wrote:
> 
> Hi,
> 
> I'm getting an error when using linked tables within Access, using ODBC to
> connect to a remote Postgres 6.5.2 database:
> 
> 'ERROR: system column oid not available - view_emp_locations is a view (#1)'
> 
> I've got the OID checkbox and fake-index checkbox ticked, as I use pgadmin
> to do the real work behind the scenes.
> 
> Any pointers for how to get views working in this fashion?
> 
> Otherwise I'll have to use a braindead-Access query which probably wants to
> pull all the data across the network first
> to just look at one row...
> 
> Cheers,
> Joe
> 
> ---
> Joe Shevland
> Principal Consultant
> KPI Logistics Pty Ltd
> http://www.kpi.com.au
> mailto:shevlandj(at)kpi(dot)com(dot)au
> 
> ************

Sounds like an old bug.  

Do you have the latest version of the driver (v.06.40.0009)?

Byron

In response to

Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2000-03-02 03:46:29
Subject: Re: [INTERFACES] Pgaccess - Error trying to connect
Previous:From: Dave Del SignoreDate: 2000-03-02 01:36:28
Subject: RE: [INTERFACES] Pgaccess - Error trying to connect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group