Robby
unread,Aug 3, 2013, 4:36:57 AM8/3/13Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to spati...@googlegroups.com
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.