[postgis-users] PostgreSQL/PostGIS Microsoft Windows Users Qu estion

Obe, Regina DND\MIS robe.dnd at ci.boston.ma.us
Fri Aug 29 11:54:46 PDT 2003


What about the ADO.NET PGSQL driver? 

http://gborg.postgresql.org/project/npgsql/projdisplay.php

But it does look like from the Esri documentation that they would support
only read-only against an ADO.NET driver and of course that definitely would
require .NET libraries and at least the .NET SDK or VS.NET to build.



-----Original Message-----
From: Paul Ramsey [mailto:pramsey at refractions.net]
Sent: Friday, August 29, 2003 12:23 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostgreSQL/PostGIS Microsoft Windows Users
Qu estion


According to the latest stuff we found on the web site, yes, it will do 
read/write on the OleDB, if you use the right version of Visual Studio 
to build the thing. (Visual Studio .NET)

http://arcobjectsonline.esri.com/ArcObjectsOnline/TechnicalDocuments/DraftCh
apters/PlugInDataSourcesDraft.pdf

If there was already a PgSQL OleDB connector, adding spatial would be 
relatively easy, just a few extra methods. Sadly, the only extant 
project appears to be half-done.

http://gborg.postgresql.org/project/oledb/projdisplay.php

Paul

Frank Warmerdam wrote:

> Paul Ramsey wrote:
> 
>> If there are enough people interested, I can put together a project 
>> plan for the "ultimate PostGIS / ArcMap connector" which would allow 
>> full read-write directly in the database. It involves the complete 
>> implementation of an OleDB provider for PostgreSQL however, so it 
>> would be fairly involved. I don't know if enough people have budget to 
>> support this kind of thing (it is almost a truism, if you already have 
>> ArcMap, you are not interested in PostGIS, although there are of 
>> course numerous exceptions to prove the rule :) We have done some 
>> small group projects in the past, where a set of PostGIS users pool 
>> funds to push a development.
>> Paul
> 
> 
> Paul,
> 
> Does ArcGIS now support read-write support via OLE DB? When I last 
> played with
> this support I thought it was read-only.  I have experience in
implementing
> a simple feature OLE DB layer (over OGR and FMEObjects) and it 
> apparently did
> work in read-only mode with ArcGIS within ESRI's labs.  I don't know if
the
> fixes they made on their side ever made it into their next release version
> or not as I no longer have a working ArcGIS license.
> 
> If full read/write support from within ArcGIS is practical via OLE DB I
> might well be able to provide some help to such a project.
> 
> I would add that in addition to PostGIS, there are folks who would like to
> see WFS-T support from within ArcGIS by some means and I had been
wondering
> if this might be practical via OLE DB.
> 
> Best regards,


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list