[postgis-users] odbc arcMap-pg

[Armin Burger]

Cedric,

I have tried to access PostGIS data via ODBC from ArcView3 and there were
problems, too. With standard ArcView SQLConnect you got maximum of 255
characters from the geometry column or errors, depending on the configuration
of the ODBC connection. With the DatabaseAccess extension the geometry field
was retrieved as blob and for every record a file *.blp was written to the
home/temp directory.

I read of similar problems of others that tried to access PostGIS via ODBC. A
test with MS Access loaded that data more or less correct but also there the
geometry column had the definition as blob.

I don't know if all that is a problem of the ODBC driver or the ESRI products
or both. Some time ago I saw a nice application loading oracle spatial data
into ArcView. So I had the idea to try something similar with PostGIS,
unfortuantely still without success. I would be interested to hear if someone
succeeded more.

One better choice might be to access Postgres by using functions of the
libpg.dll, but I'm no C programmer and therefore I dropped that possibility
for now.

Armin


> 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