DK - SQL Geodatabase Vector Layers
	FAQ Feed

Q10765 -  How can I open, view, and edit SQL database map layers with TatukGIS products? How to connect to the database? The TatukGIS DK (as of v. 8.11) GIS Editor (v. 1.11 ) and IS (v. 8.11) products support (reading and writing) the following SQL layer formats: Geomedia Access Wareh ... (Modified: 2008-01-24)

Q10783 -  How do I connect a TatukGIS product an ArcSDE SQL layer? What is supported? ArcSDE Support: The DK Spatial Database Extensions (for the VCL, ActiveX, and .NET editions) include support for the ESRI ArcSDE SQL Geodatabase vector data structure and features. This support bypas ... (Modified: 2008-01-22)

Q10779 -  How to connect a TatukGIS product to an Oracle Spatial map layer? What support for Oracle Spatial is provided? The DK Spatial Database Extensions (for the VCL, ActiveX, and .NET editions) includes support for the Oracle Spatial/Locator database vector data structure and feat ... (Modified: 2008-01-15)

Q10493 -  What is the easiest way to convert a standard SHP (or other vector) format map file into a SQL database layer? Which SQL databases products are supported? The easiest option is to use the TatukGIS Editor product to export the vector map file from any TatukGIS supported vecto ... (Modified: 2007-07-31)

Q10660 -  When the DK generates data to an SQL database file using the OpenGIS Simple Features Specifications for SQL format, does the method use Well Known Text (WKT) or Well Known Binary (WKB) format? The DK default OpenGIS (OGC) SQL DB layer storage type is OpenGISBlob, which refle ... (Modified: 2007-07-31)

Q10410 -  Can you provide more information about the TGIS_LayerSQL_XXX method for handling vector layers in SQL databases using ADO or DBX? First of all, keep in mind that TatukGIS provides three options for handling vector layers in SQL Server databases: 1) the TatukGIS specific TGIS_LayerSQL_XXX method, 2) ... (Modified: 2006-04-20)

Q10193 -  Does the DK database management system handle a coverage as one huge area or does it geometrically split the database coverage into pieces? Generally vector SQL coverages are seen as one huge database, but can be split into segments as well. Regarding the storage of raster imagery coverages to SQL ... (Modified: 2004-07-28)

Q10656 -  Should I follow any naming rules for my SQL Layer and PixelStore files? Because the layer names will be stored inside the SQL database, use names that are compatible with the database. We suggest using names without spaces and which contains only ASCII characters. This will ... (Modified: 2005-11-04)

Q10550 -  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 FAQ item Q10765) The fre ... (Modified: 2008-01-24)

Q10675 -  I notice that the Editor generates SQL map layers, by default, to the Access 97 database. Why not to the newer Access 2000 or 2003? TatukGIS products generate new files to the Access 97 database format for compatibility reasons, because this was the only version of Access that was packaged by defaul ... (Modified: 2006-01-20)

Q10272 -  When setting up a street address geocoding application, how do I load the vector street layers into a database? What kind of database works with the DK? There are two options: i) use a normal vector coverage in a SHP, MIF or other file type for the street layers or ii) "export" the vector street lay ... (Modified: 2004-12-10)

Q10480 -  How is it possible to improve the DK speed with SQL geodatabase vector layers? Please ensure that that your database has separate indexes for the UID, XMIN, XMAX, YMIN and YMAX fields. Such separate indexes are added automatically to SQL vector layers created with the DK 8 and subsequent DK versions ... (Modified: 2004-12-15)

Q10481 -  When I try to localize a shape based on its attribute, the query process is slow with my huge dataset. What can I do to increase the speed? Move the data to an SQL layer and assign (using your database tools) an index for the file you are searching on. Please remember that using the LIKE statement ... (Modified: 2004-01-30)

Q10523 -  I want to use my SQL Layers (holding vector data) to display feature tables which are joined to several other tables. How to do this? You can simply obtain a value join key for a selected shape using the standard shp.GetField function and drill down in the database on your own. If you want to open ... (Modified: 2007-01-30)

Q10524 -  How can I assign my SQL Layer (holding vector map data) Read Only access? For both OpenGIS SQL layers and TatukGIS SQL layers, you can restrict the access to "read only" status by just specifying ReadOnly=TRUE in Layer.SQLParameters of the .TTPS file. ... (Modified: 2004-04-09)

Q10698 -  How can I encrypt or control access to SQL vector layers using a user ID and password with the *ttkls file? Use the following: ado=Provider=SQLOLEDB.1;Persist Security Info=False;user id=USERID#password=PASSWORD#Initial Catalog=dados_geral;Data Source=192.168.2.91 And catch the XGIS_LayerXXX.OnPassw ... (Modified: 2006-09-29)

Q10639 -  Can I use any of the TatukGIS supported SQL database vector layer formats with an Oracle database? No. TatukGIS supports the Geomedia formats - Access Warehouse and SQL Server. GeoMedia Access Warehouse is designed to work only with Microsoft Access/Jet database on the local ... (Modified: 2008-01-25)

Q10643 -  When I try to connect to MySQL database using ODBC in order to store a vector map layer, ANY2SQL utility reports: any2sql.exe lwaters.shp test.ttkls A TatukGIS Samples - ANY-SQL converter [Microsoft]ODBC Driver Manager] Invalid string or buffer length What's wrong? Please read: http:dev.mysql.com/te ... (Modified: 2005-08-31)

Q10655 -  Which versions of Microsoft SQL Server can be used for SQL Layers or PixelStore 2 images? We have tested both PixelStore 2 and SQL Layers with MS SQL Server versions 2000, 2000 MSDE, 2005 & 2005 Express. Version 2005 was tested with both the native and standard drivers. ... (Modified: 2005-11-04)

Q10701 -  Is there a way to open an SQL layer other than using the .TTKLS file? I want to access features directly from the database, avoiding the .ttkls file. Embed into the path parameter the content of the TTKLS with a line separated by "n" ad with last line "n.ttkls" So you can use: GIS.Open( "Storage=Nat ... (Modified: 2006-09-17)

Q10725 -  I get an error when I attempt to update the features table with more then 100 columns in my MSJET based TTKLS SQL layer file? In your TTKLS file try to add the following line: Options=8 For example: [TatukGIS Layer] Storage=Native LAYER=lwaters DIALECT=MSJET ADO=Provider=Microsoft.Jet.OLEDB.4.0;Data ... (Modified: 2006-10-28)