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 18:17:35
Message-ID: 3558923F.64DD0786@nexus.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

Byron Nikolaidis wrote:
>
> Ewan Mellor wrote:
>
> > 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.
> >
>
> Wait, I think I have it!
>
> Access will not allow you to index on LongVarchar data types OR character types
> that are longer than 254 characters (255 with null). I bet these columns you
> are having trouble with are Postgres TEXT types or varchars/chars that are over
> 254.
>
> Check out the odbc driver setup options dialog. You can map TEXT fields to
> plain varchar; then set the LongVarChar size to 254, and it should work!

Well done indeed! With that you have elevated yourself to the higher
echelons of gurudom. Congratulations. :-)

One for the FAQ methinks...

Ewan.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-05-12 19:03:03 outnode error in current source
Previous Message Bruce Momjian 1998-05-12 17:39:22 Re: [HACKERS] Re: [PATCHES] Try again: S_LOCK reduced contentionh]

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jose' Soares Da Silva 1998-05-13 10:13:20 Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'
Previous Message Peter T Mount 1998-05-12 17:43:40 Re: jdbc for postgresql.