[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [udig-users] SQL 2008 Geometry
|
On Windows?
If so, have you tried creating a plain ODBC connection and then access the data as WKB via a view?
I did this with SQL Server 2008 about 3 years ago and was able to make ogr2ogr work.
S
On Wed, 10 Aug 2011 11:45:21 +1000, Stanley Sufficool <ssufficool@xxxxxxxxx> wrote:
The internal representation for SQL 2008 geometry is not WKB or WKT (.NET Serialized Geometry Class) although creating a SQL View to transform it into that would not be an issue.
The issue that is the blocker is getting a connection the server to select the table to view/edit. When using the "Integrated authentication" option the dialog will not go to the "Finish" step. The dialog reports "Connecting..." and then does not advance to the next screen. There may be an error returned by the geotools library, but it is not shown in the console or error reporting dialog.
SQL Server 2008 Express is available at no cost and would work for testing if you have a Windows box to install it on.
On Tue, Aug 9, 2011 at 4:49 PM, Jody Garnett
<jody.garnett@xxxxxxxxx> wrote:
I have not had an SQL Server to test against; the status page in the library we use does not have many open issues.
However the planned developments list "geographic" and "wkb geometry read/write". So perhaps it is only supporting WKT currently?
--
Jody Garnett
On Sunday, 7 August 2011 at 2:56 AM, Stanley Sufficool wrote:
--
Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
Email: simon@xxxxxxxxxxxxxxxxxxxx
Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3