Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxx,nvif, why atm producer might be held liable for economic injury, wwwxxxy=ServiceLogin, w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000

Links

XODOX
Impressum

#1: Best way Driver 8.04.01 with Release 9.0

Posted on 2010-12-13 00:05:22 by Jeff Silberberg

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

Report this message

#2: Re: Best way Driver 8.04.01 with Release 9.0

Posted on 2010-12-13 16:16:36 by Richard Broersma

On Sun, Dec 12, 2010 at 2:58 PM, jsilberberg@mindspring.com
<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

Report this message