Unsupported Type UUID

Hello,

I'm trying to import data from a PostgreSQL database into Microsoft
Access using the ODBC drier. Any table with a uuid column fails with
the message "Received an unsupported type from Postgres. (#14)"

Is there a setting I can use to allow the ODBC driver to import uuid
columns?

Cheers,

Adam Ruth

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Adam Ruth [ Mo, 04 Mai 2009 06:04 ] [ ID #2000039 ]

Re: Unsupported Type UUID

Adam Ruth wrote:
> Hello,
>
> I'm trying to import data from a PostgreSQL database into Microsoft
> Access using the ODBC drier. Any table with a uuid column fails with the
> message "Received an unsupported type from Postgres. (#14)"
>
> Is there a setting I can use to allow the ODBC driver to import uuid
> columns?

Please try the drivers on testing for 8.4.0100 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Hiroshi Inoue [ Di, 05 Mai 2009 16:48 ] [ ID #2000124 ]

Re: Unsupported Type UUID

Perfect! It works great. Thanks.

On 06/05/2009, at 12:48 AM, Hiroshi Inoue wrote:

> Adam Ruth wrote:
>> Hello,
>> I'm trying to import data from a PostgreSQL database into Microsoft
>> Access using the ODBC drier. Any table with a uuid column fails
>> with the message "Received an unsupported type from Postgres. (#14)"
>> Is there a setting I can use to allow the ODBC driver to import
>> uuid columns?
>
> Please try the drivers on testing for 8.4.0100 at
> http://www.geocities.jp/inocchichichi/psqlodbc/index.html
> ?
>
> regards,
> Hiroshi Inoue


--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Adam Ruth [ Di, 05 Mai 2009 22:47 ] [ ID #2000127 ]
Datenbanken » gmane.comp.db.postgresql.odbc » Unsupported Type UUID

Vorheriges Thema: INSERT on MSAccess linked ODBC table : out of memory
Nächstes Thema: odbc + refcursor + vb6