Re: Best way Driver 8.04.01 with Release 9.0

Helps alot --=20

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

JMS..


-----Original Message-----
>From: Richard Broersma
>Sent: Dec 13, 2010 10:16 AM
>To: "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
> 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:
>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 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
>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.8 5%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


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