ArcMap 10.1 / ST-Links SpatialKit for ArcMap 4.0.0

[Robby]

I was wondering if anyone who has tried out this software to have direct read / write with PostGIS and ArcMap has had success with the unlicensed version of this?  Before I buy the software I would want to see it working and for the life of me I can not make it work.

I can load a query from ArcMap 10.1 via ESRI own database connection to Postgresql / PostGIS and load the entire data set but when I try to load the data set with ST-Links it fails.  I know the next statement is their is something wrong with that layer in PostGIS.  I have 3 different layers with different SRID to make sure that is not the case.  In all cases I can load the data from PostGIS via ArcMap 10.1 own query database access and all 3 layers load in ArcMap.  Plus looking at it with other software like openjump and udig the layers all load up just fine.

I have reinstalled ST-Links 4 several times and completely removed everything I could find with regedit to make sure it did a clean install.

Just wondering if other people have tried to get this link working between ESRI and PostGIS with out ArcSDE?

This is the error I get when trying to load one layer.  Seem to me like something is not being set correctly.  When I try to load a different table I get "The coordinates or measure are out of bounds." after 100 records.  Then it loads after a ton of errors and I get a few polygons that are incorrectly loaded and with the wrong spatial reference.  Anyways, I was wondering what other people experience is with this 3rd party plugin?  Dose everyone have problems with it and just walk and move to something else??  If so then I would like to know what else allows for native R/W Access to PostGIS??

Thanks!  Error message below is for a layer in PostGIS when trying to load via ST-Links but the layer will load just find and project just fine when using the query database link in ArcMap 10.1 for postgresql but ST-Links give this error when trying to load the same layer!?!?!?!

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Specified cast is not valid.
   at c.a(STConnectionItem A_0)
   at d.b(Object A_0, EventArgs A_1)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ESRI.Production.Framework.Desktop
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Framework.Desktop/10.1.0.0__49f88df635890024/ESRI.Production.Framework.Desktop.dll
----------------------------------------
ESRI.ArcGIS.Catalog
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Catalog/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Catalog.dll
----------------------------------------
ESRI.ArcGIS.System
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.System/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.System.dll
----------------------------------------
ESRI.DADF.Core
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.1.3143
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.1/bin/ESRI.DADF.Core.DLL
----------------------------------------
msvcm90
    Assembly Version: 9.0.30729.4926
    Win32 Version: 9.00.30729.4926
    CodeBase: file:///C:/Windows/WinSxS/x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4926_none_508ed732bcbc0e5a/msvcm90.dll
----------------------------------------
ESRI.Production.Solution.Engine
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Solution.Engine/10.1.0.0__49f88df635890024/ESRI.Production.Solution.Engine.dll
----------------------------------------
ESRI.Production.Solution.Engine.Interop
    Assembly Version: 10.1.0.0
    Win32 Version: 10, 1, 0, 1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Solution.Engine.Interop/10.1.0.0__49f88df635890024/ESRI.Production.Solution.Engine.Interop.dll
----------------------------------------
ESRI.Production.Engine.Interop
    Assembly Version: 10.1.0.0
    Win32 Version: 10, 1, 0, 1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Engine.Interop/10.1.0.0__49f88df635890024/ESRI.Production.Engine.Interop.dll
----------------------------------------
ESRI.ArcGIS.Carto
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Carto/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Carto.dll
----------------------------------------
ESRI.Production.Reviewer.Desktop
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Reviewer.Desktop/10.1.0.0__49f88df635890024/ESRI.Production.Reviewer.Desktop.dll
----------------------------------------
ESRI.Production.Solution.Desktop.Interop
    Assembly Version: 10.1.0.0
    Win32 Version: 10, 1, 0, 1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Solution.Desktop.Interop/10.1.0.0__49f88df635890024/ESRI.Production.Solution.Desktop.Interop.dll
----------------------------------------
ESRI.Production.Desktop.Interop
    Assembly Version: 10.1.0.0
    Win32 Version: 10, 1, 0, 1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Desktop.Interop/10.1.0.0__49f88df635890024/ESRI.Production.Desktop.Interop.dll
----------------------------------------
ESRI.ArcGIS.Framework
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Framework/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Framework.dll
----------------------------------------
ESRI.ArcGIS.Geodatabase
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Geodatabase/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Geodatabase.dll
----------------------------------------
ESRI.Production.Framework.Engine
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Framework.Engine/10.1.0.0__49f88df635890024/ESRI.Production.Framework.Engine.dll
----------------------------------------
ESRI.Production.Internal.Engine.Interop
    Assembly Version: 10.1.0.0
    Win32 Version: 10, 1, 0, 1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Internal.Engine.Interop/10.1.0.0__49f88df635890024/ESRI.Production.Internal.Engine.Interop.dll
----------------------------------------
System.Xml.Linq
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
STSpatialKit
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.0.0
    CodeBase: file:///C:/apps/ST_Links/STSpatialKit/stspatialkit.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
ESRI.ArcGIS.ArcMapUI
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.ArcMapUI/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.ArcMapUI.dll
----------------------------------------
ESRI.ArcGIS.Geometry
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Geometry/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Geometry.dll
----------------------------------------
ESRI.ArcGIS.Display
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Display/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Display.dll
----------------------------------------
ESRI.Production.Reviewer.Engine.Interop
    Assembly Version: 10.1.0.0
    Win32 Version: 10, 1, 0, 1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Reviewer.Engine.Interop/10.1.0.0__49f88df635890024/ESRI.Production.Reviewer.Engine.Interop.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Data.DataSetExtensions
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.DataSetExtensions/3.5.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
ESRI.ArcGIS.Editor
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Editor/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Editor.dll
----------------------------------------
ESRI.ArcGIS.SearchUI
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.1/bin/ESRI.ArcGIS.SearchUI.DLL
----------------------------------------
ESRI.ArcGIS.SearchControl
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.1.3143
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.1/bin/ESRI.ArcGIS.SearchControl.DLL
----------------------------------------
ESRI.ArcGIS.SearchCore
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.1.3143
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.1/bin/ESRI.ArcGIS.SearchCore.DLL
----------------------------------------
ESRI.ArcGIS.Search
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Search/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Search.dll
----------------------------------------
ESRI.ArcGIS.SystemUI
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.SystemUI/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.SystemUI.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
ESRI.ArcGIS.Version
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Version/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Version.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
ESRI.ArcGIS.Geoprocessing
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Geoprocessing/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Geoprocessing.dll
----------------------------------------
GpMetadataFunctions
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.1.3143
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.1/bin/GpMetadataFunctions.DLL
----------------------------------------
System.Data.SqlXml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll
----------------------------------------
System.Xml.Xsl.CompiledQuery.1
    Assembly Version: 0.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll
----------------------------------------
Lucene.Net
    Assembly Version: 2.9.2.1
    Win32 Version: 2.9.2.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Lucene.Net/2.9.2.1__402f1553d5c332e7/Lucene.Net.dll
----------------------------------------
Snowball.Net
    Assembly Version: 2.0.0.1
    Win32 Version: 2.0.0.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Snowball.Net/2.0.0.1__402f1553d5c332e7/Snowball.Net.dll
----------------------------------------
ESRI.ArcGIS.MxCommands
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.1.3143
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.1/bin/ESRI.ArcGIS.MxCommands.DLL
----------------------------------------
PresentationFramework
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.6920.4902 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/PresentationFramework/3.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
WindowsBase
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.6920.4902 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
PresentationCore
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.6920.4902 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
ESRI.ArcGIS.Desktop.AddIns.Factory
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.1/bin/ESRI.ArcGIS.Desktop.AddIns.Factory.DLL
----------------------------------------
ESRI.ArcGIS.Desktop.AddIns
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.1/bin/ESRI.ArcGIS.Desktop.AddIns.DLL
----------------------------------------
ESRI.ArcGIS.MapCenter
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.1.3143
    CodeBase: file:///C:/Users/Robby/AppData/Local/ESRI/Desktop10.1/AssemblyCache/%7B9A7F5664-C531-E97B-BAF7-531921945CF6%7D/ESRI.ArcGIS.MapCenter.dll
----------------------------------------
ESRI.ArcGIS.ADF.Local
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.ADF.Local/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.ADF.Local.dll
----------------------------------------
ESRI.ArcGIS.ArcGlobe
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.ArcGlobe/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.ArcGlobe.dll
----------------------------------------
ESRI.ArcGIS.ArcScene
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.ArcScene/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.ArcScene.dll
----------------------------------------
ESRI.Production.Solution.Desktop
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.1074
    CodeBase: file:///C:/Windows/assembly/GAC_32/ESRI.Production.Solution.Desktop/10.1.0.0__49f88df635890024/ESRI.Production.Solution.Desktop.dll
----------------------------------------
Npgsql
    Assembly Version: 2.0.12.0
    Win32 Version: 2.0.12.0
    CodeBase: file:///C:/apps/ST_Links/STSpatialKit/Npgsql.DLL
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.0.0
    CodeBase: file:///C:/apps/ST_Links/STSpatialKit/Mono.Security.DLL
----------------------------------------
ESRI.ArcGIS.DataSourcesGDB
    Assembly Version: 10.1.0.0
    Win32 Version: 10.1.0.3035
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.DataSourcesGDB/10.1.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.DataSourcesGDB.dll
----------------------------------------
Microsoft.SqlServer.Types
    Assembly Version: 10.0.0.0
    Win32 Version: 2009.0100.1600.01 ((KJ_RTM).100402-1540 )
    CodeBase: file:///C:/apps/ST_Links/STSpatialKit/Microsoft.SqlServer.Types.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[Eric]

I've been using it for over a year with an Arc 10.1/PostGIS setup. With only a few quirky exceptions with .NET, its been working great. Just out of curiosity, did you turn on the ST-Links Extension in the Customize>Extensions Menu in ArcGIS? And/or have you update .NET to at least version 3?