Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WWWXXXAPC, WWWXXX .CMD, Wwwwxxx reemine, WWWXXX.VCBA, WWWXXX.VCBA, TheboL.wwwxxxxx, WWWXXXAPC , wwwxxn.xsss, wwwxxxapc, WWWXXX.VCBA



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

Posted on 2010-12-14 00:06:25 by Jeff Silberberg

Helps alot --=20

Thank You very much. I will digest this and see what I can make work..


-----Original Message-----
>From: Richard Broersma <>
>Sent: Dec 13, 2010 10:16 AM
>To: "" <>
>Subject: Re: [ODBC] Best way Driver 8.04.01 with Release 9.0
>On Sun, Dec 12, 2010 at 2:58 PM,
><> wrote:
>> One small issue I have is that we are now using arrays in the DB and I c=
an'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:
>However, since array syntax was a PRE-9.0 feature, it would matter if
>you upgraded to the 9.0 driver.
>> In PostgreSQL  the Statement is  Select * from table where 100=
0 =3D 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.
>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
>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:
> 5%29.aspx
>Does that help?
>Richard Broersma Jr.
>Sent via pgsql-odbc mailing list (
>To make changes to your subscription:

Sent via pgsql-odbc mailing list (
To make changes to your subscription:

Report this message