From: Byron Nikolaidis <byronn@insightdist.com>
To: Ewan Mellor <em@nexus.co.uk>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'
Date: Tue, 12 May 1998 13:00:47 -0400
Message-ID: <3558803F.72A8D0F@insightdist.com> (raw)
References: <35582955.5F014F7B@nexus.co.uk>
<35585DFE.6FE69EF@insightdist.com>
<355877AC.72D6D289@nexus.co.uk>
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!
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, em@nexus.co.uk
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'
In-Reply-To: <3558803F.72A8D0F@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox