Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: SQLite database created with FireDAC cannot be opened with SQLiteStudio


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Dec 27, 2017 12:43 PM Last Post By: Markus Humm
Edigest MCE

Posts: 19
Registered: 2/22/16
SQLite database created with FireDAC cannot be opened with SQLiteStudio  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 27, 2017 9:09 AM
I tried to create an SQLite database from scratch (Driver=sqlite and default options) and (after opening the DB) I created a dummy table.

I try to open the file within SQLiteStudio, but it marks it as invalid.

Does anyone know why ?

This is the Base64 encoded database as generated by FireDAC (I 7-zipped it before encoding)

N3q8ryccAANhFLe0oQAAAAAAAABYAAAAAAAAAErGdaUAKZRFnWDIGfgmZIiOJv4xlf3Hh4AGl7vs
f6gJfVNDYXT2BRt079sg5ekc5cFOilLtIb3cgyKwUj84ovBALqb8ICzP7ukt5vjva/lyQIt/pWXh
NXNf9pvC2mp95KibBAEZTFrdKQ/dCli5iIQgGK7GVAOL4Q6G0E16l6MClPycvi2/2u38tilMiF6J
X+l+6cDD1fw9SvHX0ij9ji98pfr6AAEEBgABCYChAAcLAQABIwMBAQVdAAABAAygAAAICgEKVy+G
AAAFAREZAGQAYgBsAG8AbQBhAC4AcwAzAGQAYgAAABQKAQCyO7KTI3/TARUGAQAgAAAAAAA=
Edigest MCE

Posts: 19
Registered: 2/22/16
Re: SQLite database created with FireDAC cannot be opened with SQLiteStudio  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 27, 2017 9:14 AM   in response to: Edigest MCE in response to: Edigest MCE
Uhm ... I just tried to use .sqlite extension instead of .s3db and everything seems ok.

Sorry for the "unuseful" question.

Edigest MCE wrote:
I tried to create an SQLite database from scratch (Driver=sqlite and default options) and (after opening the DB) I created a dummy table.

I try to open the file within SQLiteStudio, but it marks it as invalid.

Does anyone know why ?

This is the Base64 encoded database as generated by FireDAC (I 7-zipped it before encoding)

N3q8ryccAANhFLe0oQAAAAAAAABYAAAAAAAAAErGdaUAKZRFnWDIGfgmZIiOJv4xlf3Hh4AGl7vs
f6gJfVNDYXT2BRt079sg5ekc5cFOilLtIb3cgyKwUj84ovBALqb8ICzP7ukt5vjva/lyQIt/pWXh
NXNf9pvC2mp95KibBAEZTFrdKQ/dCli5iIQgGK7GVAOL4Q6G0E16l6MClPycvi2/2u38tilMiF6J
X+l+6cDD1fw9SvHX0ij9ji98pfr6AAEEBgABCYChAAcLAQABIwMBAQVdAAABAAygAAAICgEKVy+G
AAAFAREZAGQAYgBsAG8AbQBhAC4AcwAzAGQAYgAAABQKAQCyO7KTI3/TARUGAQAgAAAAAAA=
Markus Humm

Posts: 5,113
Registered: 11/9/03
Re: SQLite database created with FireDAC cannot be opened with SQLiteStudio  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 27, 2017 12:43 PM   in response to: Edigest MCE in response to: Edigest MCE
Am 27.12.2017 um 18:14 schrieb Edigest MCE:
Uhm ... I just tried to use .sqlite extension instead of .s3db and everything seems ok.

Sorry for the "unuseful" question.


Another thing: your question was posted to the wrong group.
It should have gone into the FireDAQ one and not in the Firemonkey one.

Greetings

Markus
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02