ITGIS_LayerSqlGmMsSpatialAbstract interface

DK11 for ActiveX | TatukGIS_XDK11.ITGIS_LayerSqlGmMsSpatialAbstract | Interfaces | Methods | Properties

Encapsulation of abstract Geomedia SQL Server Native Spatial layer.

Available also on: Delphi | .NET | Java | ActiveX.

// C#
public interface ITGIS_LayerSqlGmMsSpatialAbstract: ITGIS_LayerVectorSqlAbstract
{
}

' VisualBasic
Public Interface ITGIS_LayerSqlGmMsSpatialAbstract
  Implements ITGIS_LayerVectorSqlAbstract
End Class

// Oxygene
type
  ITGIS_LayerSqlGmMsSpatialAbstract = public interface( ITGIS_LayerVectorSqlAbstract )
  end;

ITGIS_LayerVectorSqlAbstract

This layer can be opened by opening the file name_of_layer.ttkls or embedding all parameters to Path property as CRLF or '\n' delimited string.

Structure of this file must be:

[TatukGIS Layer]
Storage=GeoMediaMsSpatial
Layer=NAME
Dialect=MSSQL
GeometryColumn=geometry column name
GeometryColumnNative=native geometry column name
GeometryType=geometry|geography - geometry type name
SRID=epsg system reference id
GeometryRelationships=Server|Client - default is Client if parameter omitted
ADONET=ADO.NET connection string with MARS enabled Provider=.NET Framework data provider (InvariantName from DbProviderFactories)
LoginPrompt=1|0
ReadOnly=True|False
...
Parameters key=value
...

For example:

[TatukGIS Layer]
Storage=GeomediaMsSpatial
Layer=Rivers
Dialect=MSSQL
GeometryColumn=geom
GeometryType=geometry
GeometryRelationships=Server
ADONET=Integrated Security=SSPI;User ID=""; Initial Catalog=GIS;Data Source=PC\SQLEXPRESS;
Provider=System.Data.SqlClient

[TatukGIS Layer]
Storage=GeomediaMsSpatial
Layer=Rivers
Dialect=MSSQL
GeometryColumn=Geometry
GeometryType=geometry
GeometryRelationships=Server
ADO=Provider=SQLNCLI11.1;Integrated Security=SSPI;User ID="";Initial Catalog=GIS;Data Source=PC\SQLEXPRESS;

This layer can also be opened by providing SQLParameters property.

OnPassword event will be fired upon connecting to a database to resolve <#user#>, <#password#> or any other <#token#> embedded into connection options.

If you want to create MS SQL Server Spatial Warehouse or import to existing Warehouse, you must ensure that the database and all its objects are owned by <b>dbo</b>. All operations that create database objects will have to be done with a user account having administrative privileges on the database (membership in the <b>sysadmin</b> role eg. <b>sa</b> user). MSSQL Server objects have owners and users. All access is controlled by ownership and the use of permissions. There is another necessary to log in with <b>sysadmin</b> role during import for allows multiple users (with varying permissions) accessing to your Warehouse.

During the making new MS SQL Server Warehouse, in the beginning, all metadata tables will be created in the database. So, you don't need to create metadata structure and register features in your database with the Geomedia Database Utilities.

Note :

• Try to use the uppercase layer name (in the meaning of Layer=xxxx). Layer name could or could not be case insensitive on different database engines.

• If you check DE9-IM coincidence between geometry objects, you should take into consideration the setting of GeometryRelationships. You may decrease the amount of returned rows from the server.

• To work with ADO.NET and new SQL server 2008 geometry types, the ttkADONET.dll and Microsoft.SqlServer.Types.dll from Microsoft SQL Server System CLR Types libraries are required for client applications.

• To force reading other geometry columns of a layer the GeometryColumn parameter can be added to a ttkls file :

  [TatukGIS Layer]
  ...
  GeometryColumn=Geometry2