Q&A - Question

TatukGis Viewer can't open sqlite protected layer

Question

MarG asked on September 09, 2019, keyword: Viewer / Editor

Using this document :

"https://docs.tatukgis.com/DK11/api:dk11:delphi:gislayersqlsqlite.tgis_layersqlsqlite "

I tried to connect to a password protected layer in sqlite DB via TatukGis Viewer.

But the Viewer shows error : "file is not a database". How can I open that in Viewer?

Also, I noticed " If a Sqlite client supports encryption, a layer will pass a key from Password to a database in 'PRAGMA key' format command. " How can I set this 'PRAGMA key' ?

My ttkls file format is here :

  [TatukGIS Layer]
  Storage=Native
  Layer=ROADS
  Dialect=SQLITE
  Sqlite=mydb.sqlite
  Password=password

Answers

IñaJ replied September 07, 2019

I have this problem too. Any idea?

Artur Redzko (TatukGIS) replied September 09, 2019

To use the encryption, you need a special Sqlite library distribution with implemented one of these extensions: SEE, SQLCipher, SQLiteCrypt, etc. The SEE and SQLiteCrypt require the purchase of a license. TatukGIS products use a normal distribution without the encryption extension.

Setting a password for a sqlite database connection in .ttkls file can be done using either Password or PRAGMA key commands.

[TatukGIS Layer]
...
PRAGMA key=test123
Password=test123

If you would like to answer the question please Sign In.

Stay signed in on this computer

Please review our recent Privacy Policy.
If you have any questions or requests, please contact us.

Forgotten password

Rules

The Questions and Answers (Q & A) is intended to provide a means of communication between TatukGIS customers.

Licensed users (with active maintenance play) of TatukGIS products may contribute to the Q & A content. Read-only access is available to anyone.
Keep the content positive and professional.
Be courteous to others by posting information when a question or issue asked on the Q & A is answered or resolved by other means (such as with help from TatukGIS technical support). Offer others at least a hint how the posted question was answered or the issue was resolved.
The Q & A is not a replacement for TatukGIS technical support. TatukGIS team may or may not regularly follow or contribute content.