DK11 for Delphi | GisLayerSqlGmFireDac.TGIS_LayerSqlGmFireDac | Classes | Constructors | Fields | Methods | Properties

Encapsulation of GeoMedia SQL layer via FireDac (dbExpress).

// Delphi
type
  TGIS_LayerSqlGmFireDac = class( TGIS_LayerSqlGmAbstract )
  end;

// C++ Builder
class PASCALIMPLEMENTATION TGIS_LayerSqlGmFireDac : public TGIS_LayerSqlGmAbstract
{
};

→ TObject → TGIS_BaseObjectDisposable → TGIS_LayerAbstract → TGIS_Layer → TGIS_LayerVector → TGIS_LayerVectorSqlAbstract → TGIS_LayerSqlGmAbstract

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=GeoMedia
Layer=NAME
Dialect=MSJET|MSSQL
ReadOnly=True|False
LoginPrompt=1|0
DriverID=see FireDAC help for TFDConnection
Database=see FireDAC help for TFDConnection
User_Name=see FireDAC help for TFDConnection
Password=see FireDAC help for TFDConnection
Server=see FireDAC help for TFDConnection
...
Parameters key=value
...

For example:

[TatukGIS Layer]
Storage=Geomedia
Layer=pwaters
Dialect=MSSQL
LoginPrompt=0
DriverID=MSAcc
Database=gm.mdb

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.

Note

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