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

Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'

From: Ewan Mellor <em(at)nexus(dot)co(dot)uk>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'
Date: 1998-05-12 16:24:12
Message-ID: 355877AC.72D6D289@nexus.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
Byron Nikolaidis wrote:
> 
> Set the "Recognize Unique Indexes" to disabled (unchecked).
> Then, when Access asks you for a unique field, don't select anything and
> hit ok.
> Thus, you are telling access you have no index.
> 
> This should allow you to get at your data until we figure out what "name"
> has to do with this problem.

I tried that, but it does not seem to help.  Perhaps Access is asking
for the index information of its own accord?

I have just discovered it also objects to:

rt_url,
url,
genre,
name_en,
stored,
stored1,
address, and
server.

Note that many have succeeded.  Curiouser and curiouser...

Thanks, Byron, both for your help and for what looks like it will be a
really useful driver.  If only the whole planet didn't use Access...

> Byron
> 
> Ewan Mellor wrote:
> 
> > I am using Byron's ODBC driver (version .0239 downloaded today) with
> > Access 7.00 under Win95 with Postgres 6.3.  I am trying to link tables
> > into Access.  Most tables work fine, but any field with the name 'name'
> > or 'sortname' or even 'garbagename' may not be used as part of an
> > index.  This occurs whether the index is picked up automatically by the
> > driver, or if you are asked to choose a unique field by Access.
> >
> > Can this be fixed?  As a workaround, could the driver optionally not
> > tell the client application about indices?  In this way, I could tell
> > Access to ignore them and then (I think) I would be able to get at my
> > data.
> >
> > Ewan Mellor.

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-05-12 16:38:11
Subject: Re: [PATCHES] Try again: S_LOCK reduced contentionh]
Previous:From: Ewan MellorDate: 1998-05-12 16:08:58
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1998-05-12 17:00:47
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'
Previous:From: Ewan MellorDate: 1998-05-12 16:08:58
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'

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