[postgis-users] odbc arcMap-pg

[Cedric BERNIER]

Hello everybody,

I'm trying to create a dynamic ODBC connection between a PC WIN 2k with ESRI's
ArcGIS 8.1 and a PC Linux RedHat 7.2 with Postgresql 7.1.3/PostGis

I've used psqlodbc-07_01_0010.zip available on http://odbc.postgresql.org
to install the ODBC driver for postgres on Win 2k,
I have configured the DSN driver to connect with Linux server.
When I run ArcMap, and I add an OLE-DB connection using my ODBC DSN, I can see
the whole content of my database (every tables are represented)

The problem is :
When I choose to add a table with geometry column to my TOC in ArcMap : there is
an error :

[Image]


Although, if the table I add doesn't have any geometry column there is another
error :

[Image]


Is there any limitation in using ODBC links with postgis or postgres , I mean
type mismatch between both application ArcMap - postgres ??

Maybe access right limitations ?


Thank for your help
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020426/ef3cfa74/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: E:\Temp\nsmailPT.jpeg
Type: image/jpeg
Size: 8569 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020426/ef3cfa74/attachment.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: E:\Temp\nsmail4A.jpeg
Type: image/jpeg
Size: 3939 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020426/ef3cfa74/attachment-0001.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cedric.bernier.vcf
Type: text/x-vcard
Size: 377 bytes
Desc: Carte pour Cedric BERNIER
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020426/ef3cfa74/attachment.vcf>