KB10550 - How can I open, view, and edit GeoMedia files using TatukGIS products?

The TatukGIS DK, Editor, and IS products support (reading and writing) the GeoMedia Access Warehouse and GeoMedia SQL Server formats (as well as other SQL layer formats covered in Knowledge Base item KB10765). The free TatukGIS Viewer product can be used to read/display GeoMedia Access Warehouse map layers.

The SQL nature of the GeoMedia formats requires the creation of a *.ttkls file with the connection settings between the TatukGIS product and the GeoMedia layer. TTKLS is a stub file used for connecting TatukGIS products to SQL database map layers. The *.ttkls file for a Geomedia layer can be created i) using any text editor (such as Note Pad) or ii) using the SQL connection Wizard feature in the Editor product (refer to menu item: Layer/Add SQL Layer).

The *.ttkls files for connecting to Geomedia layers must be as presented below. This presentation assumes that the connections use the ADO interface. (Connecting via the DBX interface requires the skills of a specialist.)


If the GeoMedia data is on an SQL server:

1) Create an ODBC connection (within the Microsoft Windows O/S) to your data

2) Create a yourname.ttkls text file

; ;[TatukGIS Layer]
; ;Storage=Geomedia
; ;LAYER= name_of_the_layer
; ;DIALECT=MSSQL
; ;ADO=YOUR_DSN_NAME

3) Open yourname.ttkls


If the GeoMedia data is in MDB (MSJET/Access):

1) Create a yourname.ttkls text file

; ;[TatukGIS Layer]
; ;Storage=Geomedia
; ;LAYER=name_of_the_layer
; ;DIALECT=MSJET
; ;ADO=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your_database.mdb

2) Open yourname.ttkls


If you wish to create a new Geomedia database layer (not supported in the free Viewer product) the procedure is:

create a *.ttkls file (in the Wnidows O/S) to connect to the data, or

manipulate layer.SQLParams directly

Refer to Knowledge Base item KB10418 for more about SQLParams and about how to bypass the *.ttkls file.

Created: 2005-09-14, Modified: 2009-10-26