Обсуждение: Access, Views and the OID
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@kpi.com.au
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@kpi.com.au > > ************ Sounds like an old bug. Do you have the latest version of the driver (v.06.40.0009)? Byron
<sound of someone booting themselves> Thanks very much for that, I've got .0006 so I'll upgrade. I thought I had a pretty recent one, but anyway, mustn't be. Thanks, Joe -----Original Message----- From: owner-pgsql-interfaces@postgreSQL.org [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Byron Nikolaidis Sent: Wednesday, 1 March 2000 7:44 PM To: Joe Shevland Cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Access, Views and the OID 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@kpi.com.au > > ************ Sounds like an old bug. Do you have the latest version of the driver (v.06.40.0009)? Byron ************