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

Access 2000 & Views

From: "Alan R(dot) Johns" <alan(at)graphicsuniversal(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Access 2000 & Views
Date: 2001-11-06 17:27:02
Message-ID: NEBBJIECOLDILFFDGNMNOEJBCHAA.alan@graphicsuniversal.com (view raw or flat)
Thread:
Lists: pgsql-odbc
I'm having a problem when trying to link to a PostgreSQL view from Access
2000. I get the following error: "The size of a field is too long.". There
is nothing "long" about any of my fields and I've tried to link to even the
simplest of views receiving the same error. Regular tables link with no
problems.

With Access 97, the exact same view(s) will link just fine and are fully
accessible. Am I missing something?

Specs:
  Redhat 7.2
  PostgreSQL 7.1.3
  PostgreSQL ODBC 7.1.0008

Thanks for any help.

-Alan


Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2001-11-06 19:02:35
Subject: Re: Weird problem with aggregate functions
Previous:From: Andy HallamDate: 2001-11-06 15:38:22
Subject: ODBC and Native error codes

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