Best way Driver 8.04.01 with Release 9.0

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.

TIA,
JMS..

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Best way Driver 8.04.01 with Release 9.0

On Sun, Dec 12, 2010 at 2:58 PM, jsilberberg@mindspring.com
wrote:

> One small issue I have is that we are now using arrays in the DB and I ca=
n't find a way to
> access them in MS Access 2007 with the OBDC Driver 8.04.01.

Unfortunately, the ODBC driver for 9.0 wasn't ready at the time of
release. You can get the 9.0 version here:
http://www.postgresql.org/ftp/odbc/versions/msi/

However, since array syntax was a PRE-9.0 feature, it would matter if
you upgraded to the 9.0 driver.

> In PostgreSQL =A0the Statement is =A0Select * from table where 1000 =3D A=
NY(array_entry);
> As documented in chapter 8.14.5
>
> Tried this syntext in MS Access 2007 with no joy, does anyone happen to k=
now how this
> should be handled in MS Access read only Selects.

MS-Access should support this query using either a pass-through query
or an ADODB result-set. Ordinary queries or DAO results set will not
work.

Also, how are you passing the "array_entry?" If you are actually
passing an array to a pass-through query, it might not work. I
haven't tried it so I don't know, but I would expect it to. If your
using pass-through queries, it would be better to pass a comma
delimited string to a query like:

Select * from table where 1000 =3D ANY( string_to_array( "1,2,3,4,5,6","," =
));

Although, it seems that and ADODB command can have arrary parameters.
Which could return a result set directly from an array. Notice:
http://msdn.microsoft.com/en-us/library/ms675318%28v=3Dvs.85 %29.aspx

Does that help?

--=20
Regards,
Richard Broersma Jr.

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc