We have moved a server to PostgreSQL 9.n this past weekend with great results so far.
One small issue I have is that we are now using arrays in the DB and I can't find a way to
access them in MS Access 2007 with the OBDC Driver 8.04.01.
In PostgreSQL the Statement is Select * from table where 1000 = ANY(array_entry);
As documented in chapter 8.14.5
Tried this syntext in MS Access 2007 with no joy, does anyone happen to know how this
should be handled in MS Access read only Selects.
pgsql-odbc by date
|Next:||From: Richard Broersma||Date: 2010-12-13 15:16:36|
|Subject: Re: Best way Driver 8.04.01 with Release 9.0|
|Previous:||From: Hiroshi Inoue||Date: 2010-12-09 10:31:44|
|Subject: Re: Problem with psqlodbc|