SQLite Driver (C11)

1

Hello -

What’s the correct syntax to assign OWER(Password) when using SQLite driver in Clarion? SV shipping sqlite example school - has this

GLO:SQLiteTableName  = 'school.sqlite'

Will it be:

GLO:SQLiteTableName  = 'school.sqlite; Password=myPassword'

Thanks,
Rex

2

Looks like it:
https://www.connectionstrings.com/sqlite/

3

Apparently, that’s not working. It ends up creating actual file with that name:

image
image822×88 4.94 KB

4

Encryption is not supported on the SQLite driver.

5

Hi, I did not try it, but assuming you have the correct extensions, I imagine you could open a non password protected database and ATTACH the protected one with an early PROP:SQL.

https://www.sqlite.org/see/doc/trunk/www/readme.wiki

ATTACH DATABASE 'file2.db' AS two KEY 'xyzzy';
6

Thank you.

I was just trying to password protect the db. to prevented opening by another app, not trying to encrypt data. It seems that password only works if Encryption Extension is purchased.