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

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: MS Access & PsqlODBC: Invalid field name 'name'
Date: 1998-05-12 10:49:57
Message-ID: 35582955.5F014F7B@nexus.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
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.

Responses

pgsql-hackers by date

Next:From: Jose' Soares Da SilvaDate: 1998-05-12 11:02:43
Subject: Re: [INTERFACES] Re: NEW ODBC DRIVER
Previous:From: D'Arcy J.M. CainDate: 1998-05-12 10:41:23
Subject: Re: [HACKERS] money or dollar type

pgsql-interfaces by date

Next:From: Jose' Soares Da SilvaDate: 1998-05-12 11:02:43
Subject: Re: [INTERFACES] Re: NEW ODBC DRIVER
Previous:From: Olaf MittelstaedtDate: 1998-05-12 08:50:22
Subject: Re: NEW ODBC DRIVER

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