Re: Best way Driver 8.04.01 with Release 9.0

Helps alot --

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

   JMS..


-----Original Message-----
>From: Richard Broersma <richard.broersma@gmail.com>
>Sent: Dec 13, 2010 10:16 AM
>To: "jsilberberg@mindspring.com" <jsilberberg@mindspring.com>
>Cc: pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] Best way Driver 8.04.01 with Release 9.0
>
>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 can'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  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.
>
>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 = 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=vs.85%29.aspx
>
>Does that help?
>
>--
>Regards,
>Richard Broersma Jr.
>
>--
>Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-odbc