Joe Shevland wrote:
> 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...
> Joe Shevland
> Principal Consultant
> KPI Logistics Pty Ltd
Sounds like an old bug.
Do you have the latest version of the driver (v.06.40.0009)?
In response to
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2000-03-02 03:46:29|
|Subject: Re: [INTERFACES] Pgaccess - Error trying to connect |
|Previous:||From: Dave Del Signore||Date: 2000-03-02 01:36:28|
|Subject: RE: [INTERFACES] Pgaccess - Error trying to connect|